On Sat, May 3, 2008 at 10:21 AM, emel <emel@...> wrote:

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

Hi eMel,

What I actually meant is that if you have a non-standard feature in an
RDBMS, you shouldn't expect it to exist on all RDBMSs, which is the
case of updates with joins. Even though MySQL and Access have
implemented it, it doesn't mean that other RDBMSs will accept the
syntax as it is. You will have to find out how to implement it your
target RDBMS, which in the current example you have provided is the
equivalent to the update with joins.

Fidel.