Jay

select c.clientid,sum(p.amount),sum(cr.amount)
from clients c join payments p on p.clientid=c.clientid
join cred cr on c.clientid=cr.clientid 

where c.datestart < dateadd(dd,1,'03/31/07')
and p.description like '%monthly contrib%'
or p.description like '%monthly payment for acct%'
group by c.clientid
order by c.clientid