題解 | #返回顧客名稱和相關(guān)訂單號(hào)#
返回顧客名稱和相關(guān)訂單號(hào)
http://www.fangfengwang8.cn/practice/7e7bc361db6a4cb6aa35eefccfe75364
SELECT a.cust_name, b.order_num FROM Customers a INNER JOIN Orders b ON a.cust_id = b.cust_id ORDER BY a.cust_name, b.order_num
思路:
1.查詢顧客名稱,來源于表a
2.查詢訂單號(hào),來源于表b
3.根據(jù)用戶id聯(lián)結(jié)表