I'm having trouble getting the following work. Can anyone help me?(adsbygoogle = window.adsbygoogle || []).push({});

I have two tables that look like the following:

How do I join both of them such that the end result would be this?Code (Text):

Table 1 Table 2

A B A B C

1 4 1 4 6

2 5

3 6

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.Code (Text):

Result

A B C

1 4 6

2 5 null

3 6 null

**Physics Forums | Science Articles, Homework Help, Discussion**

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# SQL Help?

**Physics Forums | Science Articles, Homework Help, Discussion**