Hi everyone,

Is there a way to update a table A with values from another table B
when the two tables share same field value?
I've tried this, but it doesn't work:

update tableA
inner join tableB on tableA.field1 = tableB.field1
set tableA.field2 = tableB.field2

is there a way to do this in firebird? Thanks