[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