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

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.
UPDATED:  April 10, 2017