SQL查询问题 [英] problem with query in sql

问题描述

大家好

我遇到这样的问题

我有4张这样的桌子

Hello everyone

I got a problem like this

I have 4 table like this

Customer(CusID), Bill(BillID, CusID) and 
BillDetails(BillID, ProductID, Price, Amount), Product(ProductID)

我想列出每个客户及其所有账单所花费的钱(价格*金额).
有人可以帮我吗?任何评论将是适当的
非常感谢

I want to list of each customer and it money spent(Price*Amount) for all bills.
Could any one help me please? Any comment will be appriciate
Thanks very much

推荐答案

SELECT ''MONEY SPENT'' = Price * Amount FROM BillDetails

只需加入即可获得其他详细信息.

希望对您有帮助！

问候，
爱德华(Eduard)

Just do the joining for other details.

Hope it helps!

Regards,
Eduard

尝试如下查询.

Try as below Query.

Select C.CusID, Sum((BD.Price * BD.Amount)) as MoneySpent
From Customer C
Inner Join Bill B on C.CusID = B.CusID
Inner Join BillDetails BD on B.BillID = BD.BillID
Group By C.CusID;

这篇关于SQL查询问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！