این چی؟:


select sum(Price) as TotalPaid, tblmostajer.mID ,sum(RentPrice) - sum(TotalPaid) AS remainder

from tblACC , tblMostajer

where tblACC.mID=tblMostajer.mID

Group by tblmostajer.mID