看到这个2个表加上中间表一张,想到3个方式,分别为子查询(好理解),内连接(如下展示),隐式内连接(采用传统的where 加上比较 实现)。 tips: 1. 牛客这里表名称得按照规定来,此题大写首字母Customers 3表内连接 SELECT c.cust_name, o.order_num, (o.quantity * o.item_price) AS 'OrderTotal' FROM Customers AS c INNER JOIN Orders AS oc ON c.cust_id = oc.cust_id INNER JOIN OrderItems AS o ON oc.ord...