Modify the SQL statement you just created to list all customers, even those with no orders.


SELECT cust_name, order_num
FROM Customers
 LEFT OUTER JOIN Orders ON Customers.cust_id = Orders.cust_id
ORDER BY cust_name;

Comment on this FAQ