UPDATE from COUNT(*) of another table in DB2 - HOW?

[jlrolin]

I'm trying to update a new field in a table from a COUNT(*) of Registration IDs grouped by Course IDs.

COUNT: Course_ID
11 1234
12 2323
19 8932

I want to populate a NUM_REG field in another table with the COUNT from this query to the records that have matching Course_IDs.

Similar to this situation:

update a 
set a.cnt = b.cnt 
from table2 a, 
        (select widget_type, count(*) as cnt 
         from table1 
         group by widget_type) b 
where a.widget_type = b.widget_type 
 

Only problem is, that code will not work in DB2, keeps giving me an error about unexpected token after the beginning of the statement.

Any suggestions?

[Snib]

I do not have Db2 running on my server to try this SQL but you should be able to do it with something like:

update table2 as a
set a.cnt = (Select count(*)
from table1 as b
where a.widget_type = b.widget_type)

Regards

Snib