select p.prod_name,o.order_num from Products p left join OrderItems o on p.prod_id = o.prod_id order by p.prod_name