Subject Re: update from 2 tables
Author Adam
--- In, "cbll_lam" <cbll_lam@...>
> 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

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


> 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?
> regards,
> bill