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

SELECT Table1.Id, 
       SUM(Owned) AS Owned,
       SUM(Paid)  AS Paid,
       SUM(ISNULL(Table2.TPaid,0)) AS TPaid
FROM Table1
LEFT JOIN Table2 ON Table1.Id = Table2.Id
GROUP BY Table1.Id