Now that you understand the mechanics of inner and outer joins, you are ready to delve into more advanced join techniques. In this lesson, you learn:
What full joins are and why you might need them
The power of self-joins
How to utilize union queries
What subqueries are and how to take advantage of them
How to ...