> Joao Henrique Levada wrote:
>>>
>>> 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.

Exactly. Therefore FB 2.1 implemens standard MERGE statement.

Regards,
Vlad