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
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.