给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!
:)