VERIFIED SOLUTION i

MIapnfo Pro and the SQL Query dialog for ODBC tables

Product Affected: MapInfo Pro™
 
To get to the SQL Query dialog in MapInfo Pro ver. 12.x and later,
users must first create a "DSN" (Data Source Name) to the desired database connect to that database.
Then with the DSN connection open, go to Home > Open Table, change the "Files of type" drop-down to the DSN ODBC connection, found at the bottom of the list.
Select a table to query and then click on Options > Expert Mode > SQL View where you can enter or load the desired SQL Query. 

User-added image
UPDATED:  August 1, 2019