SQL Oracle联接问题，表未联接

Question

我想问题是我在某个地方加入了我的订单ID不在一起

我不知道如何修复

select l.orderid, sum(l.qty) as units_sold, sum (l.qty) * p.price as Sales_Amount
from order_lines l join
products p
on p.prodid = l.prodid
group by l.orderid, p.price
Order by sum(l.qty) * p.price 

有点喜欢户外运动。231未加入

OrderID.          Units sold.       Price
231.                       5.                   5
243.                        6.                   6
246.                        7.                   7
231.                        8.                    8
247.                        6.                     9

Answer 1

我怀疑您实际上想要：

select l.orderid, sum(l.qty) as units_sold, sum(l.qty * p.price) as Sales_Amount
from order_lines l join
products p
on p.prodid = l.prodid
group by l.orderid
Order by Sales_Amount ;

group by子句指定要如何定义结果集中的行。如果每个orderid只需要一行，那么group by中应该只有orderid。