Subject join in an update ?
Author olivier_lucaes
Hello there,
I'm trying to update one column for some rows of a table1 having a
null value with values from another table (2). Is there anyway to do
something similar with Firebird (it seems that this syntax is valid
with MS SQL Server) :

update table1
set table1.col1 = table2.col1
from table1
inner join table2 on table1.col2 = table2.col2
where table1.col1 is null
and table2.col1 is not null

Thanks in advance for any tip.

Best regards