Very didactic!
Thank you eMel.. (and Good English ;) )

Cesar.

emel escribió:

>
> >> It works well in MySQL and Access.
> >> I also have other similarities with delete.
> > "Just because something works in Oracle, MySQL, Access, or what have
> > you, it doesn't mean it is going to work in Firebird. It will only
> > work in all RDBMSs if they all follow the standard."
>
> But it's an answer for a problem.
> If a thing is prevalent at other, it's not a coincidence.
>
> for example:
>
> UPDATE tambe1 T1 SET
> T1.Value3 = '....',
> T1.value1 = (
> SELECT T2.value1
> FROM table2 T2
> WHERE T2.id = T1.id
> ),
> T1.value2 = (
> SELECT T2.value2
> FROM table2 T2
> WHERE T2.id = T1.id
> )
> ... and so on
> WHERE
> T1.id = 199522
>
> eMeL
>
> Sorry for my english ;)
>
>