Walter Meester
HoogkarspelNetherlands
General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only