🚀 go-pugleaf

Thank you for all your valuable input. I have been developing database
application for years so I am not that newbie.

Maybe I did not put my question very clear so everyone is confused with my
intention. Let met put it this way:

Let's say PROJECTS is a table created from an external file: abc.txt. While
NEW_PROJECTS is a corresponding internal table. After some manipulation in
the NEW_PROJECTS table, I want to export the changes made back to the
PROJECTS table (and thus reflect the change in abc.txt). Then my concern to
export the data in a certain order makes perfect sense.

Tks for any input.

TR@SOE


"TR@SOE" <tr@netease.com> д����Ϣ����:3df890a9@newsgroups.borland.com...
> INSERT INTO PROJECTS
> SELECT * FROM NEW_PROJECTS
> WHERE NEW_PROJECTS.START_DATE > ��6-JUN-1994��;
>
> I know the above can work. But my question is:
>
> Can I add an "ORDER BY" to the SELECT? If yes, how? Something like:
>
> INSERT INTO PROJECTS
> SELECT * FROM NEW_PROJECTS
> ORDER BY ...
>
> doesn't work.
>
> If not, what to do if I want to insert into one table with some rows from
> another dataset which is somehow sorted?
>
> Rgds!
>
> TR@SOE
>
>