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.查询订单号,来源于表b

3.根据用户id联结表