|Subject||Re: [firebird-support] Re: Update format|
> Joao Henrique Levada wrote:Exactly. Therefore FB 2.1 implemens standard MERGE statement.
>>> I am migrating an application from MySQL to FB2.0.3 (on Linux).
>>> Can not solve the following query:
>>> UPDATE tambe1 T1
>>> INNER JOIN table2 T2
>>> ON T1.id = T2.id
>>> SET T1.value = T2.value
>>> WHERE T1.id = 199522
>> I never seen a update with a inner join.
>> Can this be?
> It's a common, but non-standard extension to SQL. Like many
> non-standard extensions, it's pretty intuitive and useful in
> simple cases, but leads to very odd corner conditions.