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.


Regards,


Ann