[V4MD] ORDER BY and JOIN

[william humphrey]

Try order by column 1

On Fri, Sep 26, 2008 at 11:19 AM, Caliste_l <caliste_l at yahoo.fr> wrote:

> 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
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>



-- 
http://www.bluewatermaritime.com