SELECT prod_name, order_num
FROM Products P
LEFT JOIN OrderItems O on P.prod_id = O.prod_id
ORDER BY prod_name