- #1
KataKoniK
- 1,347
- 0
I'm having trouble getting the following work. Can anyone help me?
I have two tables that look like the following:
How do I join both of them such that the end result would be this?
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.
I have two tables that look like the following:
Code:
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:
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.