Tracy,

Try

SELECT id, sum(t1.owed) AS owed, sum(t1.paid) AS paid, 
		(SELECT SUM(tpaid) FROM table2 t2 WHERE t1.id = td2.id)  AS tpaid
	GROUP BY id

>I have 2 sql server 2005 tables:
>
>table1
>
>id
>owed
>paid
>
>table2
>
>id
>tpaid
>
>I want to pull:
>
> sum(table1.owed) as owed, sum(table1.paid) as paid, sum(table2.tpaid) as tpaid
> where table1.id = table2.id
>
>There are multiple records for each id in both tables. It seems simple, but I just can't seem to get it right. Any ideas?