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

Thanks! I followed the output from the view designer and it was worthless. your method is just about a quarter sec to join 1800 + records for my shipping / BOL system.