>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?

I think that subqueries are only supported in the WHERE clause for the UPDATE command.

>
>Thanks in advance