Quite a few of you have emailed me wondering if I found a solution to the problem
I had in selecting objects. Here is a summary of the advice I was given.
I had unit postcode points for all of Scotland, and a copy of 1991 Census settlements.
I wanted
to use MapInfo to give me all the postcode points that weren't inside any settlement
polygon.
It is so easy to get the ones within the polygons but not so obvious to get the ones
outside.
>From the replies I got the most straightforward way to do it is to enter in to the
>SQL select
dialog the following statement (where the postcode point data was Table1 and the
census
settlement polygon file was Table2) :-
Select Columns - *
>From Tables - Table1
Where Condition - not Table1.obj within any (select obj from Table2)
Into Table Named - whatever
So the syntax is:-
Select * from Table1 where not obj within any (select obj from Table2)
Thanks very much to everyone that answered!
David Watkins
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
