O'Reilly logo

Inside Microsoft® SQL Server™ 2005: T-SQL Querying by Dejan Sarka, Lubor Kollar, Itzik Ben-Gan

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Joins

Joins are operations that allow you to match rows between tables. I informally referred to these operations as horizontal ones because the virtual table resulting from a join operation between two tables contains all columns from both tables.

I’ll first describe the different syntaxes for joins supported by the standard, and I’ll also mention the proprietary elements in T-SQL. I’ll then describe the fundamental join types and their applications followed by other categorizations of joins. I’ll also have a focused discussion on the internal processing of joins—namely, join algorithms.

You’ll have a couple of chances to practice what you’ve learned by trying to solve a problem that encompasses previously discussed aspects of joins.

Old Style vs. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required