题解 | 返回顾客名称和相关订单号
SELECT cust_name, order_num FROM Customers INNER JOIN Orders ON Customers.cust_id=Orders.cust_id ORDER BY cust_name
FROM TableA
INNER JOIN TableB ON TableA.___=TableB.___
SELECT cust_name, order_num FROM Customers INNER JOIN Orders ON Customers.cust_id=Orders.cust_id ORDER BY cust_name
FROM TableA
INNER JOIN TableB ON TableA.___=TableB.___
相关推荐