SELECT name, order_id

FROM customer, salesorder

WHERE customer.customer_id = salesorder.customer_id

UNION ALL

SELECT name, NULL

FROM customer

WHERE customer.customer_id NOT IN (SELECT customer_id FROM salesorder)

ORDER BY name;