General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only