题解 | 返回产品名称和与之相关的订单号
select prod_name, order_num from Products pro left join OrderItems ord on pro.prod_id = ord.prod_id order by prod_name asc
select prod_name, order_num from Products pro left join OrderItems ord on pro.prod_id = ord.prod_id order by prod_name asc
相关推荐