I am getting a strange error within GIS, when using the internal MapInfo Select query for objects.
SELECT featurecode, area(obj,"sq km"),theme, DescriptiveGroup,count(*) from mastermap_topo_497145_0_Topogr GROUP BY featurecode
Shows up all the results, with the area in KM, now when its applied to an object area, for example to select all objects within a distance of a point, even a large value it does not give the same results.
The counts are equal (only one layer) per featurecode, but the area calculations are wrong and vastly different as if the SQL command is not selecting all the objects but the object count is equal,
BTW the point creation / sql is via MapInfo Basic.
Just very odd to get the same objects two different results.