Cesar L. Meloni escribió:

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

Please excuse my Spanish!!
True! Thank you Sean!
Also works well in Others (Ann, is standard Tks!)