题解 | #返回产品名称和与之相关的订单号#
返回产品名称和与之相关的订单号
http://www.nowcoder.com/practice/c369a759436a4e8b80baa9c39e9adf18
- 使用左外连接,A表未被连接的记录,它的B表的字段为NULL。
SELECT prod_name, order_num
FROM Products p
LEFT JOIN OrderItems ot ON p.prod_id = ot.prod_id
ORDER BY prod_name ASC