Welcome to collectivesolver - Programming & Software Q&A with code examples. A website with trusted programming answers. All programs are tested and work.

Contact: aviboots(AT)netvision.net.il

Prodentim Probiotics Specially Designed For The Health Of Your Teeth And Gums

Instant Grammar Checker - Correct all grammar errors and enhance your writing

Teach Your Child To Read

Powerful WordPress hosting for WordPress professionals

Disclosure: My content contains affiliate links.

31,166 questions

40,722 answers

573 users

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

2 Answers

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

 





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

 





answered Sep 19, 2015 by avibootz

Related questions

...