LEFT, RIGHT, INNER and FULL JOIN in SQL Server

JOINS in SQL Server

In this post, the SQL Join statement/clause is used to combine data or rows from two or more tables based on a common field between them. Different types of Joins are following:

  • LEFT JOIN
  • RIGHT JOIN
  • INNER JOIN
  • FULL JOIN
SELECT Order.OrderID, Customers.CustomerName, Order.OrderDate
FROM Order
INNER JOIN Customers ON Order.CustomerID=Customers.CustomerID

2020-04-01