Select "Missing From Table 2", {Columns you want to see - Same as in Union Part 2}
From Table1 Left Join Table2
On Table1.JoiningKey=Table2.JoiningKey
Where Table2.JoiningKey Is Null
Union
Select "Missing From Table 1", {Columns you want to see - Same as in Union Part 1}
From Table2 Left Join Table1
On Table2.JoiningKey=Table1.JoiningKey
Where Table1.JoiningKey Is Null