The answer depends on the form in which your data are assembled. I'll
assume these are selections from the same table; the first, TWOMILE, is
all the people within 2 miles of some location, and the second,
FIVEMILE, is everyone within 5 miles of that location. In this case
FIVEMILE also contains all those in TWOMILE. You will also need to have
a unique identifying field in both, and let's call it something
original, like 'Id'. Then the SQL select statement is:
select * from FIVEMILE where Id not in (select Id from TWOMILE) into
THREEMILE
The result, THREEMILE, contains all those within 5 and beyond 2 miles of
your site. The unique identifying field can be a number or a string; the
only requirement is that no two records in your data have the same value
for it.
- Bill Thoen
Erin OHara wrote:
>
> I have a radius of 2 miles and all the volunteers within that radius. I
> also have a radius of 5 miles and all the volunteers within that 5 mile
> radius. What I want is a list of the volunteers that live in the 3 miles
> between. In other words those people that are in the 5 mile group minus the
> people in the 2 mile group.
>
> Ideas? Anyone? Would be very greatful and might even write in complete
> sentences if I get the answer.
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
