It work
Thank's Sergey
>Try to move
ON clause after related
JOIN.
SELECT Solde.stpsp, Solde.stvqp1, Livre.lnum,;
> Livre.lnom, Livre.lnoma, Livre_a.lnum, Livre_a.lnom,Livre_a.lnoma;
> FROM(lSolde) as Solde ;
> LEFT OUTER JOIN (lLivre);
> ON Solde.stpsp = Livre.lnum ;
> LEFT OUTER JOIN (lLivre) Livre_a ;
> ON Solde.stvqp1 = Livre_a.lnum ;
> INTO CURSOR cGltaxe
>
>
>
>>Hi All
>>I try to run this query but I always get this error
>>
>>SQL: Column stvqp1 is not found
>>
>>I have made this query in the query designer and it work just fine
>>I copy it in my code and replace the table name with lsolde and llivre
>>
>>lpath = Thisform.prppath && 'c:\Avantage Win\Ava01\
>>
>>lSolde = Thisform.prppath+"Solde.dbf'
>>lLivre = Thisform.prppath+"Livre.dbf'
>>
>>SELECT Solde.stpsp,Solde.stvqp1,Livre.lnum,; Livre.lnom,Livre.lnoma,Livre_a.lnum, Livre_a.lnom,Livre_a.lnoma;
>>FROM(lSolde) as Solde ;
>>LEFT OUTER JOIN (lLivre);
>>LEFT OUTER JOIN (llivre) Livre_a ;
>>ON Solde.stvqp1 = Livre_a.lnum ;
>>ON Solde.stpsp = Livre.lnum INTO CURSOR cGltaxe
>>
>>any tip's