Pitney Bowes MapInfo Professional - Manual (Page 242)

We have now built the expression "Select all countries whose population density (pop_1994/Area(obj,
"sq mi")) is more than (>) 500 people per square mile."
12. Leave the Group by Columns box blank.
13. Tab to the Order by Columns box and select Country from the Columns list.
The Order by Columns box allows you to specify the order the records in the query table will display.
By selecting Country, MapInfo Professional will list the records in alphabetical order, according to
country name.
14. Tab to the Into Table Named box and type DENSITY.
By default, MapInfo Professional names the query table Query1. Subsequent query tables will be
named Query2, Query3, and so on. You can change the name of the query table by typing in a new
table name in the Into Table Named box. MapInfo Professional will name the query table DENSITY.
15. Click Verify. MapInfo Professional checks the syntax of your SQL statement. If there are any errors
in your statement, MapInfo Professional gives you an error message telling you what the error is and
which box contains the error.
16. Select the Browse Results check box to create a Browser of the query table. If you do not select
Browse Results, MapInfo Professional still creates the temporary query table but does not display
it. If you wanted to display the table after the fact, choose the Browse option in the Window menu
and select DENSITY from the drop-down list.
17. To display the query results in the currently active Map window, select Find Results in Current Map
Window. If there are no open Map windows, this check box is disabled. You cannot save this check
box setting to a template. This option is cleared by default.
MapInfo Professional 12.5 242
Querying Your Data in MapInfo Professional