>Hi Erik,
>
>>SELECT ARCust.*, Address1.Address, Address2.Address FROM ARCust, Address Address1, Address Address2 WHERE ARCust.AddressID1 = Address1.ID and ARCust.AddressID2 = Address2.ID
>
>This won't work, saddly. This will eliminate records which don't have the optional shipto address, where a left join leaves an unmatched in. I was hoping to do something like:
>
>
select a.arno, b.lname, c.lname as shiplname;
> from ar a left join address b on a.id_addr = b.id_addr,;
> ar a left join address c on a.id_ship=c.id_addr ;
> into cursor temp
>
>whcih doesnt work, so I
Oh- I didn't realize you needed an outer join. What happens with the syntax above? looks good to me...
Erik Moore
Clientelligence