题解 | #SQL87#
返回顾客名称和相关订单号以及每个订单的总价
https://www.nowcoder.com/practice/4dda66e385c443d8a11570a70807d250
select c.cust_name, o1.order_num, (o2.quantity*o2.item_price) as OrderTotal from Orders o1 left join Customers c on c.cust_id = o1.cust_id left join OrderItems o2 on o1.order_num = o2.order_num order by cust_name,order_num asc;
一种三表联合查询的方式。
查看25道真题和解析