Hi Mike and others

Try something like:

Select <CIRCLES>.Col1, Count(*) from <BUSINESSES>, <CIRCLES> where
<BUSINESSES>.OBJ within <CIRCLES>.OBJ group by <CIRCLES>.COl1 into

Browse * from RESULTS

This assumes that the first column in <CIRCLES> is a unique identifier
of some sort.

If you do not have unique identifiers for your circles try using:
Update <CIRCLES> set col1 = rowid

to give them unique ID's first.

I haven't got time to check the syntax but it should point you in the
right direction.

Hope it helps,


Mike Eden
Senior Technical Services Manager
RSK Environment (UK) Ltd.
+44 (0)1928 726006

> -----Original Message-----
> From: Mike C Kallas [mailto:[EMAIL PROTECTED]]
> Sent: 12 July 1999 19:39
> Subject: MI Businesses in Circles
> Any suggestions?
> I'm trying to determine the number of businesses within 
> several circles.
> I have a TAB file named circles and can get a count of the TOTAL 
> businesses in the circles, however I need the COUNT for individual 
> circles.  I believe I could name all the circles and change the names 
> in the Query each time, however that is very time consuming.
> Any suggestions are welcome.
> Thanks
> ---------------------
> Mike Kallas
> Sprint Corporation
> Broadband Local Networks
> Site Application Planning
> Network Analyst II
> Office: 913.906.7704
> Pager: 1.800.724.3329 PIN 3827193
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

Reply via email to