Hi there.
You can perform the point by either using SQL query dialog or the
mapbasic window. This is how to do in the SQL Query dialog box:
For the purpose of this example:
- poly is the polygon table
- poly.area is the key field in the polygon (poly) table
- Points is the point table
SQL SELECT:
Select Column: poly.area, count(*)"Number_of_Points"
>From tables: poly, points
Where Condition: poly.Obj Contains points.Obj
Group by: poly.area
Order by column:
Into Table Named: Poly_Point_Count
If you want to use the mapbasic window, here is the sql query:
Select poly.area, Count(*)"Number_of_Points" from poly, points where
poly.Obj Contains points.Obj group by poly.area into Poly_Point_Count
Browse * From Poly_Point_Count
That should work for you but if you find any problem let me know.
Othman Issa
Mgr - Bell ActiMedia
Toronto, Canada
416-412-5899
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
