I am attending and speaking at SQL Saturday Redmond today.
My presentation is at 2:45pm and on SQL JOIN Types, and the following topics will be 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.
For those of you following the Database Corruption Challenge, I am stepping away from the challenge until at least late Saturday night, or sometime on Sunday. If you are waiting to hear back if your solution was accepted, I probably won’t get to it until Sunday.
If you attended this session and would like to give me feedback, please fill out my feedback form.