Re: MI Selecting objects not within another - solution

2000-03-08 Thread David Watkins
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

Re: MI Selecting objects not within another - solution

2000-03-08 Thread Erick Posner
Or you could do this way: Select * from Table1 where not Table1.obj within any Table2.obj - Original Message - From: David Watkins [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 08, 2000 1:40 AM Subject: Re: MI Selecting objects not within another - solution Quite

MI Selecting objects not within another?

2000-03-07 Thread David Watkins
Any ideas about what I can write in a SQL select statement to select all the objects in one layer that do not lie within an objects in the layer above. It seems top be so straight forward to select those that lie within an object on the upper layer, so presumably I am missing something