Subject Re: [firebird-support] Re: Update format
Author Ann W. Harrison
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 =
>> SET T1.value = T2.value
>> WHERE = 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.