SQL Joins
Craig Freedman has written an excellent article on SQL joins
This is the first of several posts that I am planning for joins. In this post, I’m going to start by introducing the logical join operators that SQL Server supports. These are:
- Inner join
- Outer join
- Cross join
- Cross apply
- Semi-join
- Anti-semi-join
And if you read this and liked it, here’s his follow up post on Subqueries: ANDs and ORs
In fact, for those of you wanting to know all about joining tables in your queries, I have rarely seen it better explained than in this series of posts.
