I'm having trouble getting the following work. Can anyone help me? I have two tables that look like the following: Code (Text): Table 1 Table 2 A B A B C 1 4 1 4 6 2 5 3 6 How do I join both of them such that the end result would be this? Code (Text): Result A B C 1 4 6 2 5 null 3 6 null I tried to do the right, left, normal joins, and union, but I still cannot get it to show like the resulting table. Any help would be great, thanks.