MapInfo SQL Select - used to return Object Types (point, line...etc)

Video #76
In this video I use MapInfo Pro to return object types: POINT, LINE and REGION using the standard SQL Select dialog.
- Some features are drawn in the Cosmetic Layer
- Those objects are saved to a MapInfo TAB
- I then use UPDATE COLUMN to add ROWID to the new layer

For an overall report of all types use:

Select ID, str$(obj), Count(*) from mytable group by 2

To find out what each individual record object type is, then enhance the GROUP BY with an existing unique identifier:

Select ID,str$(obj), Count(*) from mytable group by 1,2

MapInfo can store multiple geometry types in the TAB format so this might be useful when you want to dissect such a table of features.

[Blackmamba]

Hi. Could I use this to select data from two tables or only select from one table ar a time?