题解 | 返回产品名称和与之相关的订单号
返回产品名称和与之相关的订单号
https://www.nowcoder.com/practice/c369a759436a4e8b80baa9c39e9adf18
select prod_name,order_num from Products A left join OrderItems B on A.prod_id=B.prod_id union select prod_name,order_num from Products C right join OrderItems D on C.prod_id=D.prod_id where C.prod_id is null order by prod_name