Interactively selecting objects – Pitney Bowes MapInfo Professional User Manual
Page 239
Type 90.
Click Verify to confirm the syntax of your expression. Click OK to close the Verify dialog box.
5. Click OK to close the Expression dialog box. The Select dialog box redisplays.
6. Select the Browse Results check box.
7. Click OK. MapInfo Professional creates a Browser that contains the selections. Notice that the
selections display in both the World map and Browser.
Making a New Table Using a Subset of a File
Many of the data sets that are used with MapInfo Professional include more objects and information
than necessary for some projects. In many cases it is easier to work with a subset of the complete data
product. For example, if you were tracking crime statistics for a county by census tract, you would not
need the census tracts for the entire state.
There are two ways to create a new table that will contain a subset of the records from an existing file.
You can interactively select the objects representing the records you would like to put in the new table
using one of the select tools. Or, you can use the SQL Select command to choose a subset of objects
based on an SQL function. For an example using the SQL Select command, see
. Saving the resulting table is the same procedure, whether you choose
the objects interactively or use an SQL Select statement.
Many of the queries on the following pages can be done either by using the SQL Select command
or through the simpler Select command. Because SQL Select is more versatile and more
commonly used, the SQL Select dialog box is used in the following examples.
Note:
Interactively Selecting Objects
1. On the File menu, click Open and open the table in a Map window.
2. Select the objects that will make up the subset with the Select tool, Radius Search Selector tool,
or Polygon Search Selector tool. Shift-click to select multiple objects.
239
MapInfo Professional User Guide
Chapter 9: Selecting and Querying Data