>>>Not valid for Firebird or not valid according to the SQL specifications?

> Both.
> Ann

Good, but...

always this but ...

update tableA a
set (a.field2, a.field2) =
(select b.field2, b.field3 from TableB b
where b.field1 = a.field1)

It's standard SQL syntax and necessary for efficient work ;(

Is this feature planned?

eMeL