Subject Re: [ib-support] Firebird: has ORDER BY in INSERT INTO... FROM being added?
Author Martijn Tonies
Post date 2003-05-26T13:53:09Z
Hi Marco,

> Hi, I can't test FB RC2, so, since there is no mention in "What's new"
> document, does anyone here know if this syntax is now correct (and
> works ;))?
> insert into PhoneList(client_id)
> select client_id from Clients order by birthday

Why the ORDER BY?


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com