Contact: aviboots(AT)netvision.net.il
31,166 questions
40,722 answers
573 users
SELECT Customers.CustomerID, Customers.CustomerName, Orders.OrderID, Orders.TotalCost FROM Customers LEFT JOIN Orders ON Customers.CustomerID=Orders.CustomerID
SELECT Customers.CustomerID, Customers.CustomerName, Orders.OrderID, Orders.TotalCost FROM Customers LEFT JOIN Orders ON Customers.CustomerID=Orders.CustomerID ORDER BY Customers.CustomerID