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.