I'm looking for a Mapinfo SQL which can look at two tables and easily determine if a particular smaller bounded polygon has now moved into a different larger bounded polygon because there has been recent redistribution of particular boundaries of the larger.
The problem I have is that the smaller may in fact be intersected by more than one of the larger and the costs involved vary significantly. I have been able to table before and after, and determine any differences. I guess I am looking for a query that looks at the two tables and says OK for smaller polygon WXYZ before you intersected larger polygon 1, but now you intersect larger polygon 1, 2 and 3.
I have over 5000 smaller polygons whereas I only have 4 categorised larger polygons. How can I do this? Is it best, given that I have multiple listings for the same smaller polygons, that I actually add an ID# to both tables so any script I write understands that there can be multiples of the one location name?