Hello all,
I have two table, Poly (polygons) and Points (point data).
The Poly table is made up of many individual polygons. The Points table are
points that contain the associated textual data for the polygons.
I want to have the Points data linked to the associated polygon. e.g.
Poly.COL1, Poly.COL2, Points.COL1
The poly table has no relational field with the points table.
I know I can do an SQL to select points that are within or contained within the
polygon, but how do I get the Points data to come across in the resulting table?
I'm guessing this will require some Mapbasic, like a select, fetch first,
assign the data to a var, update the poly table, loop through and do it for the
next rec, etc... Is there any faster way I'm not seing. I have about 90 000
polygons to update.
Can someone point me to any examples or tools that may do this kind of query.
Using MI Pro 7.8
Thanks in advance...
Manny
