Stephen,

I would say:

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

Walter,