Types of Join in SQL Server – Part 1 Author: Basit A. Farooq In this two part article series, I will discuss different types of joins available in SQL Server. You use a join to combine data from different tables into a single result set. Joins most commonly use foreign key relationships. Some important points about joins include: Joins are...