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 ...
Get Sams Teach Yourself T-SQL in One Hour a Day now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
