select * from tabPoints p, tabPOLY y where p.tabPOINTS.obj NOT IN y.tabPOLY
select * from tables:
tabPOINTS,tabPOLY
where
NOT (tabPOINTS.obj within tabPOLY)
----- Original Message -----
From: Jelena Puzic <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, March 09, 2000 3:14 AM
Subject: MI SQL - excluding objects in geographic operations
Hello
Please help! I would like to make a query that uses geographic operators
but EXCLUDES objects.
Example:
The point table is called tabPOINTS and the polygon table called tabPOLY.
I would like to make a query that lists all the points from tabPOINTS table
NOT within the polygons of the tabPOLY table.
Is it possible to use SOMETHING like the following (this does not work):
select * from tables:
tabPOINTS,tabPOLY
where
NOT (tabPOINTS.obj within tabPOLY)
Any help would be greatly greatly appreciated...
Thank you so much!
jp
----------------------------------------------------------------------
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]
