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 does MapInfo take results of SQL query?
MapInfo receives the results of the SQL query and treats it as a MapInfo table. Summary: There is still more SQL power in MapInfo Pro than 99% of people will use. With standard (non-GIS) SQL you “join” tables together by matching columns and values: e.g., “…where Table1.zip = Table2.zip”.
What’s the difference between MapInfo Pro and standard SQL?
MapInfo receives the results of the SQL query and treats it as a MapInfo table. Summary: There is still more SQL power in MapInfo Pro than 99% of people will use. MapInfo’s SQL Spatial syntax: With standard (non-GIS) SQL you “join” tables together by matching columns and values: e.g., “…where Table1.zip = Table2.zip”.
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 select data that falls within a given region?
Click the Arrow on the Map>Select button and select the Boundary Selection tool. Bring the cursor on to the map and click inside the region that will be used to select the point objects that are within that region.
How to calculate the number of points within a polygon?
I need to select points which fall within polygons where the income > 1500 I tryed this one but not working: http://www.sgsi.com/MIUserGroup/imgs/sql1.jpg I also tryed this SQL code but doesn’t work: points.Obj Within polygon.Obj where income > 1500 Any idea? You can also solve the problem by using a sub select query instead of a join query.