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?
--sb--