Question

How to returns all rows from left table and matching rows from right table with LEFT JOIN in SQL

Answer 1

SELECT Customers.CustomerID, Customers.CustomerName, Orders.OrderID, Orders.TotalCost
FROM Customers
LEFT JOIN Orders
ON Customers.CustomerID=Orders.CustomerID

 

70+ SQL courses for beginners and professionals

Answer 2

SELECT Customers.CustomerID, Customers.CustomerName, Orders.OrderID, Orders.TotalCost
FROM Customers
LEFT JOIN Orders
ON Customers.CustomerID=Orders.CustomerID
ORDER BY Customers.CustomerID

 

70+ SQL courses for beginners and professionals