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