Introducing the SQL commands that allow us to perform relatively complex set operations on a database.
As with the other topics we’ve covered in this series, there is a wealth of information available on the topic of sets, databases, and SQL.
We'll get into the following topics in this stage, but here are a few links that talk a little more about Set Operations in SQL:
- What is the difference between a JOIN and a UNION?
- Learn to use UNION, INTERSECT, and EXCEPT Clauses
Other good reads about Set Operations include:
Union and Union All:
You need to sign up for Treehouse in order to download course files.Sign up