Hi Erik,

>Oh- I didn't realize you needed an outer join. What happens with the syntax above? looks good to me...

I haven't gotten it to work correctly. If I have 3 records in AR I get 9 records total, 3 addresses for each of the 3 shipto corresponding addresses. Using my UNIOINized SELECT I get the 3 records I want, 2 from the first and the one with a zero value. Like I said I will keep trying with selects similar to the one that looks good to you. Would you like to know if I find anything?