ingres 2 sorting rows in tables

[pnm_uk]

can anybody tell me how to order or sort rows in an ingres 2 DB table. The subselect statement of the sql insert command does not allow "order by" when inserting rows from another table into a new table. Or can anyone suggest a good Ingres SQL resource.

Many thanks

Pete

[sicarius]

I've never used that particular database, but why would it matter how the data is sorted when you insert it? Wouldn't it always be safer to sort the data when you retrieve it from the database?