Selecting common records from one table that are not in another in MapInfo Pro

Product Name: MapInfo Pro™
 
The following SQL statement will select records from one table which are not in another table based on a common field.
  1. In the SQL Select dialog box, fill in the syntax under 'where Condition:' 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:  December 3, 2019