Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Proper syntax for a compound join
Message
From
28/07/1999 12:23:48
Walter Meester
HoogkarspelNetherlands
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00247208
Message ID:
00247224
Views:
30
Jim,

>FROM ves!master2 LEFT OUTER JOIN arcadr01 ;
ON Master2.custno + Master2.cshipno = Arcadr01.custno + Arcadr01.cshipno

this only applies if all fields are caracter. If they're numeric you can get unexpected results. If all the mentioned fields are indexed it's maybe better to use

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

Click here to load this message in the networking platform