RE: MI objects not containing

2000-03-04 Thread Justusson Christer

Hello!

Try this: 
First select all the points within the polygons
Then make a second query to the table with points like:
not obj within any(select from selection)
Hit Enter and fetch coffee (it takes a while).
I also wonder why I can't use Not together with obj within. 
A faster way is to add a column. Select all that contains points and update
those with xxx. Select all without the value xxx.

Regards Christer J

-Original Message-
From: Jon Spinney [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 03, 2000 4:28 PM
To: Mapinfo User List (E-mail)
Subject: MI objects not containing


Dear list, 

I have a point table and a polygon table.  I want to select all polygons not
containing a point(s).  Can someone tell me how to construct an SQL that
selects polygons not containing points? 

Thanks, 

Jon
  
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]

--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]



MI objects not containing

2000-03-03 Thread Jon Spinney

Dear list, 

I have a point table and a polygon table.  I want to select all polygons not
containing a point(s).  Can someone tell me how to construct an SQL that
selects polygons not containing points? 

Thanks, 

Jon
  
--
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]