I have the following :
UPDATE snapshot2 SET oppvirkulttotaal = result (SELECT kultivar, SUM(opp) as result FROM Snapshot GROUP BY kultivar)
I want to upate column oppvirtotaal in snapshot2 with the sum in snapshot (column opp) were kultivar as the same in both tables.
When I run the statement from (SELECT ..... it works fine . The problem seems to be with my update statement.