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