Types of SQL Joins

Learn about the types of joins we can perform with T-SQL.

There are several types of JOIN operations. Each of them helps us achieve a different objective in terms of what data to return when joining. Let’s consider these two tables.

Get hands-on with 1200+ tech skills courses.