Sql查询给出多个值 [英] Sql query giving multiple values

问题描述

在我的数据库中，我的表中只有4或5条记录，但下面的查询显示12或13条记录，它显示3条记录3次等等

In my DB there are only 4 or5 records in my tables but the query below is showing 12 or 13 records it''s showing 1 record 3 times and so on

select A.Date,OwnerName,Rate,Weight,PreviousAmount from Company F inner join TrashSaleOrders C on F.Companyid=C.Companyid  inner join Accounts A on C.Companyid=A.Companyid

I想要显示订购人的姓名（OwnerName）和Orderdetails（费率，重量）和他之前的金额（PreviousAmount）（如果有的话）。表公司包含（Companyid，OwnerName）表TrashSaleOrders包含（Companyid，Date，Weight，Rate）表帐户包含（Accountid，Companyid，Date，PreviousAmount，Payment，AmountLeft）

I want to display Name (OwnerName) of person who ordered and Orderdetails (Rate,Weight) and his previous amount (PreviousAmount) if any. Table Company contains (Companyid,OwnerName) Table TrashSaleOrders contains (Companyid,Date,Weight,Rate) Table Accounts contains (Accountid,Companyid,Date,PreviousAmount,Payment,AmountLeft)

推荐答案

给group by子句看看它会解析

give group by clause and see it will resolve

连接应该是正确的，试试这个......

joins should be proper, try this...

select A.Date,OwnerName,Sum(Rate),Sum(Weight),sm(PreviousAmount)
from Company F 
inner join TrashSaleOrders C on F.Companyid=C.Companyid  
inner join Accounts A on C.Companyid=A.Companyid and A.Date = C.Date
Group by A.Date, OwnerName

快乐编码！

：）

Happy Coding!
:)

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