I have a situation where I want to get a count of grouped records from one table and update a field with the count in another table.
the select statement works fine as
select count(t1.f1) as cnt, t1.f2, t1.f3 from reviews group by t1.f2, t1.f3
Now I want to take cnt and update a field t2.f1 where t1.f2 = t2.f2 and t1.f3 = t2.f3
Every syntax I've tried I doesn't work and I can't seem to find anything in the manual. Can someone point me in the right direction. Thanks