What are SQL Server join clauses?

SQL Server - Interview Questions

The join clause combines columns with related values from two or more tables to create a new table. There are four main types of SQL join clause :

* JOIN returns records with matching values in both tables

* LEFT JOIN returns all records from the left table and matching records from the right table

* RIGHT JOIN returns all records from the right table and matching records from the left table

* FULL JOIN returns all records from both tables