>I have a table with 1600 student locks in random order. I would like them
permanently sorted by the locker number they are >assigned to. I assumed
>~ I would copy the table under a different name
>~ Delete all records from this copy
>~ Write a statement that would copy the records from the original table
into the copied table in SORTED order
>~ Delete the original table
>~ Rename the copy to the same name as the original
>Question 1: Is there a better way to get the desired result?
>Question 2: If not, what would the Insert/Select statement look like that
would copy the records over in sorted order?
Tables aren't sorted. Period.
Only result-sets can be sorted.
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Database development questions? Check the forum!