看了下其他人的解题,感觉这道题不需要group by 吧?下面是我的 select c.cust_name,a.order_num,(quantity*item_price) as OrderTotal from OrderItems a ,Orders b ,Customers c where a.order_num = b.order_num and b.cust_id = c.cust_id order ...
