How to use a SQL query in MapInfo?

From this post i will shows you how to use basic SQL Query for simple SELECT. To use it, open your mapinfo and open menu tab Query > SQL Select and will popup a new window to work using SQL command : Here the command sample :

What are the Select commands in MapInfo Pro?

MapInfo Pro has two “Select” menu commands: Query > SQL Select. “SQL Select” does everything done by the simple “Select”—only much more. What is “SQL”?

How to use linked tables in MapInfo Professional?

That does however require that you only pick up linked tables. A third suggestion would be to write a tool (MapBasic for instance) that searches a certain folder (and subfolders if you like) opens each of the tables found and refreshes the table, if it is a linked table.

How to use a search condition in MapInfo?

Column names and pseudo columns may be prefixed with a table name or a table alias followed by the dot (“.”) character. search_condition : is a reference to an expression that results in either true or false. Most of the functions in this document can be used in search conditions, but aggregation functions are not supported for this use.

How to calculate line length in MapInfo Professional?

SQL Query is a great feature for MapInfo Pro users. We can use it to do many things or tasks such as calculate areas, line length and many more. In this article, I am going to show you some example on how to calculate line length in MapInfo Professional using SQL Query.

When to use left and RIGHT OUTER JOIN in MapInfo?

LEFT OUTER JOIN (AND RIGHT OUTER JOIN) – Inclusive This searches a complete set of records from table A. Where there is matching data from table B that can be appended, if there is no matching data then it will show as null. Left is used to refer to table A and is always used to refer to the first table referenced in the query.