Hi,

Like i just said on first request....

1 Update t_client a
2 set cl001D = cl001D + (select sum(amount)
3 from t_fh_fs b
4 where a.clnbr = b.clnbr
5 and b.department = 2
6* )
SQL> /
set cl001D = cl001D + (select sum(amount)
*
ERROR at line 2:
ORA-00936: missing expression