题解 | #返回产品名称和与之相关的订单号#
返回产品名称和与之相关的订单号
http://www.nowcoder.com/practice/c369a759436a4e8b80baa9c39e9adf18
SELECT a.prod_name,b.order_num
FROM Products a
left join OrderItems b on a.prod_id=b.prod_id
union
SELECT a.prod_name,b.order_num
FROM Products a
left join OrderItems b on a.prod_id=b.prod_id
where a.prod_id is null
FROM Products a
left join OrderItems b on a.prod_id=b.prod_id
union
SELECT a.prod_name,b.order_num
FROM Products a
left join OrderItems b on a.prod_id=b.prod_id
where a.prod_id is null
order by prod_name
# orderby针对select后面的内容排序的，如果最后一行是a.prod_name则会报错，因为prod_id为空的时候，a.prod_name关联不到。
投递字节跳动等公司7个岗位 >
联想公司氛围 560人发布