Joins in SQL

Introduction

When working with databases, we want to be able to fetch the needed data as effectively and easily as possible. Oftentimes, we want to get records from two or more tables based on a common field that exists in all of them. In such cases, we should use the SQL JOIN command which does exactly this – creates a new temporary or permanent table by combining columns from multiple distinct tables. There exist four different types of Joins (left join, right join, inner join, and full outer join) and in this tutorial, we will take a look at all of them, together with some practical examples. All the examples in this tutorial will be based on the tables shown below.