[GIS] Sorting tables alphabetically in Mapinfo Professional 10

Question

I have appended one table to another, and now they are not sorted alphabetically. Is there any way to resort the table so that it is in alphabetical order?

Answer 1

You can do this using an SQL Select and then saving the query result as a new table. It should look something like this:

The sort will default to ascending order, if you want it descending add "Desc" after the column name in the 'Order By...' field.