Take a look a the LEFT JOIN example here:
SQL LEFT JOIN Keyword[
^]
In your case the query should look like this:
SELECT Customers.CustomerName, Orders.OrderID
FROM Customers
LEFT JOIN Orders
ON Customers.CustomerID=Orders.CustomerID
WHERE OrderID IS NOT NULL
ORDER BY Customers.CustomerName;