HELP! CAN'T UPDATE ACROSS TABLES USING AGGREGATE????

[stevenippon]

Hi
I'm trying to update Table1 from Table2, joining on key columns, but I want to update Table1 with the sum of data from Table2, e.g. something like

update Table1 set col2 = (select sum(col2) from Table2 where Table1.col1=Table2.col1.

Any ideas how to do this? I can do it in Sybase but I'm stuck when trying to do in Access,. (also does anyone know any decent SQL-92 websites?)

Thanks a lot
Steve

 

[mikey69]

Not entirely clear what you mean, but it is possible to get aggregates in select queries in Access. There's an icon on the query toolbar with the Greek letter sigma on it. create such a query and use it as the input for an update query.