select prod_name,order_num from Products P left join OrderItems O using(prod_id) order by prod_name ASC;