Leyne, Sean escribió:

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

Es cierto!!! Muchas gracias Sean!!!
Además funciona bien en Otras, (Ann, es standard Tks!)