How to join two tables and show unmatched rows for BOTH tables
Posted on 2006-06-07
Say I want to join table1 and table2. If I do "SELECT * FROM table1 LEFT JOIN table2 USING(SomeField)" any rows that exist in table1 yet do not exist in table2 will still show up as well as matched rows, which is good. But any rows that exists in table2 yet not exist in table 1 will not.
I want to be able to show any rows that do not exists in table1 and yet exists in table2 and any rows that exist in table2 yet not exist in talbe1, along with all the matched rows. Please help.