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 ;