Difference between revisions of "MI Selecting Subsets"

From Tuflow
Jump to navigation Jump to search
Line 1: Line 1:
 
== Introduction ==
 
== Introduction ==
MapInfo offers two methods for selecting subsets of other tables; the basic select tool and the more powerful 'sql select'. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.
+
MapInfo offers two methods for selecting subsets of other tables; the basic 'Select' tool and the more powerful 'SQL select'. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.
 
== Basic Select ==
 
== Basic Select ==
 +
<ol>
 +
<li>Import the 1d_nwk_check.mif layer into MapInfo. </li>
 +
<li>To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, Select… to display the dialog below. Ensure the correct table is selected in the 'Select Records from Table' drop down box. In the dialogue box type the following: Type = "C". Click 'OK'.
 +
  
 
== SQL Select ==
 
== SQL Select ==

Revision as of 15:05, 5 September 2011

Introduction

MapInfo offers two methods for selecting subsets of other tables; the basic 'Select' tool and the more powerful 'SQL select'. This example illustrates how the pipes (Type = “C”) in a 1d_nwk_check.mif layer are selected.

Basic Select

  1. Import the 1d_nwk_check.mif layer into MapInfo.
  2. To select all channels of Type “C” (ie. pipes or circular culverts) go to Query, Select… to display the dialog below. Ensure the correct table is selected in the 'Select Records from Table' drop down box. In the dialogue box type the following: Type = "C". Click 'OK'.

    SQL Select