Cesar,

> 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.

Won't work with Firebird, it doesn't support JOINs in UPDATE and DELETE
statements.

The working equivalent UPDATE statement would be:

UPDATE tambe1 T1 SET
T1.value = (
SELECT T2.value
FROM table2 T2
WHERE T2.id = T1.id
)
WHERE
T1.id = 199522


Sean