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

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