[V4MD] ORDER BY and JOIN
Caliste_l
caliste_l at yahoo.fr
Fri Sep 26 10:19:16 CDT 2008
Hi
I've some problem with ORDER BY and JOIN table.
this request is ok :
"SELECT nameP, IdP
FROM tblPers
ORDER BY nameP "
=> the result is ordered good
"SELECT tblPers.nameP, tblPers.IdP
FROM tblPers
LEFT JOIN tblJobLink ON tblPers.IdP=tblJobLink .IdP
LEFT JOIN tblJob ON tblJob.idJob=tblJobLink.idJob
ORDER BY tblPers.nameP"
=> the result is not ordered good
Why ??
Thanks
More information about the Valentina
mailing list