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
RESULTS
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
_______________________
Mike Eden
Senior Technical Services Manager
RSK Environment (UK) Ltd.
+44 (0)1928 726006
<mailto:[EMAIL PROTECTED]>
> -----Original Message-----
> From: Mike C Kallas [mailto:[EMAIL PROTECTED]]
> Sent: 12 July 1999 19:39
> To: [EMAIL PROTECTED]
> 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]
