Carolyn Lu Wong <carolyn(at)greatpacific(dot)com(dot)au> writes:
> Forgot to mention that I'm using V6.5.
Oh. 6.5's support for sub-selects is pretty limited :-(.
I think the only way to do it in 6.5 is with a temp table,
eg
SELECT id, sum(amount) as sum into temp table tt from t2 group by id;
update t1 set amount = tt.sum where id = tt.id;
drop table tt;
You might wanna think about updating sometime soon...
regards, tom lane