Hi Rob
Make sure your Polygon layer has a column thats unique.
Then run an SQL select with tables showing POLTAB,PNTTAB
and where saying POLTAB.OBJ contains PNTTAB.OBJ.
In the group by column put the unique column in POLTAB
Lastly put Count(*) in Select column and hey presto!!...
Regards
Bob
In message <c=CA%a=_%p=CityofSaskatoon%l=VST12E01-990727201630Z-
[EMAIL PROTECTED]>, Gilhuly, Rob (LS - Program
Services) <[EMAIL PROTECTED]> writes
>I'm using MI 5.5 and when I do a SQL query it looks like some records
>that fall within the query are not selected (e.g. SQL query for postal
>codes LIKE "S7J%%%")... then when you look at the map with the postal
>code layer on, some of the postal code points that are for S7J sites are
>not highlighted like all the others. When you look at the selection
>table, these postal codes seem to have been captured in the query, just
>not highlighted on the map.
>
>This occured in the 5.0 version as well... any comments, ideas?
>
>Rob Gilhuly, Research Coordinator
>City of Saskatoon
>Community Services Department - Leisure Services Branch
>mailto:[EMAIL PROTECTED]
>http://www.city.saskatoon.sk.ca/departments/leisure/research
>
>----------------------------------------------------------------------
>To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
>"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
--
Bob Young
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
