SELECT CustomerID, CompanyName, OrderID FROM customers AS c
LEFT JOIN orders AS o USING (CustomerID)
WHERE o.OrderID IS NULL;