>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,

Needed this change to compile: \/
ON Master2.cshipno = Arcadr01.cshipno ON Master2.custno = Arcadr01.custno

But it still took 3 min and brough back wrong data. I sent you Jim Booth's correct method of ON custno + cshipno = custno + cshipno

Thanks.