Sunday, September 11, 2016

FULL Joins

photo credit: Hold My Hand via photopin (license)
A FULL join are a great way to find data that missing in two joined tables. The full join is the combination of the LEFT and RIGHT join In the case of my example I am comparing inventory between two different tables where an item may be missing in either table.

If you run this SQL you will see that inventory1 is missing items divisible by 7, while inventory2 is missing items divisible by 8.

No comments:

Post a Comment