TSQL JOIN Types – SQL Saturday

Today I am presenting at SQL Saturday in Redmond Wa. My presentation is on SQL JOIN types. If you have seen my JOIN Types Poster, you should check it out.

Download the slides and sample TSQL code:

JOINs.zip

Topics Covered

• —Basic SELECT
• —INNER JOIN
• —LEFT OUTER JOIN
• —RIGHT OUTER JOIN
• —LEFT OUTER JOIN with exclusion
• —RIGHT OUTER JOIN with exclusion
• —SEMI JOIN
• —ANTI SEMI JOIN
• —CROSS JOIN
• —FULL OUTER JOIN
• —FULL OUTER JOIN with exclusion
• —CROSS APPLY
• —OUTER APPLY
• —Multiple combinations of JOINs.

My favorite slide from the presenation:

Related Links

• JOIN Types Poster
• INNER JOIN
• FULL JOIN vs CROSS JOIN
• OUTER JOINS

Try our JOIN Types Course:

Comes Complete with:

• Easy to understand lectures with examples

• Assignments

• Sample code to work with

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!