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

2 Answers

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

 



answered Sep 20, 2015 by avibootz
0 votes
SELECT Orders.OrderID, Orders.TotalCost, Customers.CustomerID, Customers.CustomerName
FROM Orders
RIGHT JOIN Customers
ON Orders.CustomerID=Customers.CustomerID
ORDER BY Orders.OrderID

 



answered Sep 20, 2015 by avibootz

Related questions

1 answer 338 views
2 answers 435 views
2 answers 870 views
3 answers 985 views
2 answers 578 views
...