Re: QUERY not working use of subselects is too

[Roland Bouman]

You don't seem to need Table A at all, is that correct:

SELECT b.id
, b.sumAmount
, c.sumAmount
FROM (select id, sum(amount)
from B
group by id
) b
inner join (select id, sum(amount)
from C
group by id
) c
on b.id = c.id

I hope it helps, but if you're tables are properly indexed, it should not make too much of a difference