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:

Image What full joins are and why you might need them

Image The power of self-joins

Image How to utilize union queries

Image 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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.