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

Tag