> This being the case, I'd use a join update.
>

So from what you mention, can I take this as FB does not allow the
following?

UPDATE table1, table2
SET table1.field2 = table2.field2
WHERE table1.field1 = table2.field2;

Could you provide a simple sample of the JOIN UPDATE please


daniel