VERIFIED SOLUTION i
X

MapInfo Pro-:How to select records from one table that are not in another

UPDATED: April 10, 2017


The following SQL statement will select records from one table which are not in another table based on a common field.

1. Choose Query > SQL Select and fill in the dialog box as follows substituting the table being used for the table in the example.

User-added image

NOTE: The syntax for the where condition is as follows: NOT column name IN (SELECT column name FROM second table)

The SQL statement in this example will produce a query table of all records in table 'ASSAY' that do not exist in the 'ASSAY2' table.

Environment Details


 

Downloads

  • No Downloads