--- In firebird-support@yahoogroups.com, "cbll_lam" <cbll_lam@...>
wrote:

>
> ms access uses syntax
> update a, b set a.p=b.q where a.x=b.y
>
> but FB uses
> update a set a.p=b.q from a, b where a.x=b.y

FB does not accept that syntax.

You would get

Statement failed, SQLCODE = -104

Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 22
-from

In a race for Standards compliance with Access and FB, it is no
contest.

Adam

>
> I guess old ansi sql allows update statement on a single table only.
> What standard does FB now follow in this case? or has ansi sql
> standard relaxed?
>
> TIA
>
> regards,
> bill
>