Re: Determine Balance Due from Two Tables

[Courtney Marton]

I believe that this query should work:

select r.clientid,r.name,
totalcost,totalpaid,totalcost-totalpaid
from
(select sum(tblregistration.amount) as totalcost
from tblregistration,tblclient
where tblregistration.clientid = tblclient.clientid
group by tblregistration.clientid) as r,

(select sum(tblpayment.amount) as totalpaid
from tblpayment
group by tblpayment.clientid) as p

where r.clientid = p.clientid

Unfortunately my web host is running version 4.0.23 and, thus, I cannot use this nested select. Is there a workaround?

Thanks!
Courtney