Hi bill,

>
> I'm not alone in this issue, and I guess this may become an recurrent

question.

> If I read correctly, SQL Standard here refer to SQL92 (SQL2?) which is
> 2006-1992=14 years old, and Firebird itself have non-standard

feature. Why call

> non-standard features of Firebird extensions; depreciate extensions

of other

> dbms as non-standard features?
>
> IMO market force rules not sQL92 standards. Just my 2 cents.
>
> regards,
> bill
>

I am not a native english speaker,
Actually, i haven't been learning it for more than 25 years.
neither english is a regular language nor i am an idiot.
anyway,
"update x set ... from x join y..." syntax seen mongol to me,
even as an english sentence.

if you really need to join some tables for update,
FB doesnt break you:

update mytable m1 set myfield='FB rocks!'
where
m1.id=(select m2.id from mytable m2
inner join myothertable mo on mo.id=m2.id
where m2.id=m1.id
)

SQL orginally created to intend to use Databases via natural speak.
SQL may be still primitive today but shouldnt to broke natural language
struct and modern math rules via complex sentence.

just my 2 cents from my mastercard. ;)

Regards.
Ali