Little more than Left & Right Joins

[Shreenivas Potnis]

Left-Outer-Join gives all matching records in Table1 &
Table2 along with the extra records in Table1.
Right-Outer-Join does the same except it leaves the extra
records in Table1 but gives those in Table2.

However I want matching records plus extra records in the
Table1 and Table2. How do I acheive this?

 

[Douglas J. Steele]

Union together a Left Join and a Right Join.