Lynn Pettis (5/8/2013)
dwilliscp (5/8/2013)
...I have found one other strange thing..
The outer join has data in the columns for details_2, so I do not understand how in the heck it is doing the link between the two tables... there shouldn't be anything on the details_2 side.
Your query in the original post is SELECT * ..., this means you are going to see the all the columne from both tables used in the query.
True, but since this Delivery only exists in one table I would expect the columns related to the Details_2 to be NULL, but they are not.