Using a Join Query in Remote Tables - MapInfo_Pro - 2023

MapInfo Pro is unable to process an INNER JOIN or JOIN query to an ODBC table when the table is mappable. As a workaround, use the Where clause instead of using INNER JOIN or JOIN to join two tables.

For example:

SELECT t1.c1, t2.c2 FROM t1 INNER JOIN t2 ON (t1.c1 = t2.c2)

May be modified to:

SELECT t1.c1, t2.c2 FROM t1, t2 WHERE t1.c1 = t2.c2

If there are conditions in the Where clause, then use AND to join conditions. For example:

SELECT t1.c1, t2.c2 
FROM t1 INNER JOIN t2 ON (t1.c1 = t2.c2) 
where t1.c1 > 2 or t2.c2 < 100

May be modified to:

SELECT t1.c1, t2.c2 
FROM t1, t2 
WHERE t1.c1 = t2.c2 AND (t1.c1 > 2 or t2.c2 < 100)