The documentation says that subquerys are allowed with update-sql but I have never got one working. I want to assign a value to a field as result of a subquery. I have tried something like this. The result of the subquery is unique and has the same type like the target field.

update fauk_work set attribute25=(select attr from fa_dept_conv where code=fauk_work.attribute22)

Any ideas?

Thanks in advance