Question

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

Answer 1

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

 

70+ SQL courses for beginners and professionals

Answer 2

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

 

70+ SQL courses for beginners and professionals