Lesson 9. Powerful Join Techniques
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 ...