Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Proper syntax for a compound join
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Proper syntax for a compound join
Miscellaneous
Thread ID:
00247208
Message ID:
00247208
Views:
65
I have 2 tables that need a compound join for proper results.

Custno + Cshipno are identical in both tables

Would you :

Regular stuff here : ;
FROM ves!master2 LEFT OUTER JOIN arcadr01 ;
ON Master2.custno = Arcadr01.custno ;
where Master2.cshipno = Arcadr01.cshipno ;

or :


FROM ves!master2 LEFT OUTER JOIN arcadr01;
LEFT OUTER JOIN ves!master2 ;
ON Master2.cshipno = Arcadr01.cshipno ;
ON Master2.custno = Arcadr01.custno ;
Next
Reply
Map
View

Click here to load this message in the networking platform