select t1.prod_name , t2.order_numfrom Products t1left join OrderItems t2 on t2.prod_id = t1.prod_idorder by t1.prod_name/*SQL*/...