--- In firebird-support@yahoogroups.com, "Cesar L. Meloni" <cesar@...>
wrote:

>
> Hello everyone!!!
>
> 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
>
> It works well in MySQL and Access.
> I also have other similarities with delete.
>
> Thank you all !!!
>
> Cesar L. Meloni
> Unifix
>

I never seen a update with a inner join.

Can this be?