TSQL JOIN Types – SQL Saturday

Download PDF

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.

TSQL JOIN Types

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:

CanIJoinYou

 

Related Links

Posted in SQL Saturday Tagged with: ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*

Time limit is exhausted. Please reload CAPTCHA.