Subject Re: join in an update ?
Author olivier_lucaes
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.
--- In, "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
> something similar with Firebird (it seems that this syntax is
> 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