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