In this tutorial I will explain and demonstrate the three main categories of joins in SQL Server. These are Inner Joins, Outer Joins & Cross Joins. I will also cover using the Query Editor tool which is SQL Server's graphical tool for creating SQL code. Then to wrap up, the tutorial, I will show you how to join three or more tables.

The code to create the database and tables used in this tutorial are available at www.analyticsinaction.com/joins/

As a FYI, joins is a topic in the "Querying Microsoft SQL Server Exam, - 70-461". This is the first exam in the Business Intelligence Certification. In this tutorial I will cover off joins in enough detail to satisfy the exam requirements.

I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-...