Introduction to Basic SQL, Part 3 - Complex Joins and Sub-queries

In my previous article, I covered SQL Joins with two tables. Today, I will cover joining tables with three or more tables and using sub-queries to join. I'll also throw in some details about the UNION clause and show other places a sub-query might be used.