Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Query problem
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00703879
Message ID:
00703933
Views:
15
You're welcome.

>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
>>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform