Sorry everybody, I have found same topic in some old messages (using
sub select for each field needing an update).
I will use this solution.
thanks and sorry for being too fast for posting.
Olivier
--- In firebird-support@yahoogroups.com, "olivier_lucaes"
<olivier.lucaes@...> wrote:

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