[V4MD] ORDER BY and JOIN

[Caliste_l]

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