SQL103 返回产品名称和与之相关的订单号(left join.. on..)

select prod_name,order_num from Products P left join OrderItems OI   on P.prod_id = OI.prod_id
order by prod_name;

让数据条多的表位于左边。