You can use NOT with geographic operators, but this is by no means
straightforward in MI. If you want to select non-intersecting objects from
table1 and table2 use:
Select * from table1 where Not Obj intersects Any (select obj from table2)
into
Selection
Hope this helps.
Mikhail
-----Original Message-----
From: Litea Biukoto <[EMAIL PROTECTED]>
To: MapInfo-L (E-mail) <[EMAIL PROTECTED]>
Date: 4 ����� 1999 �. 1:59
Subject: MI SQL - excluding objects
>Bula!
>
>I'm having trouble carrying out queries that will exclude certain objects
>from a table. For example, when trying to isolate objects overlaying a
>certain layer. This is simple if you're dealing with only 3 layers, one
>with the objects you're concerned with and the other 2 just backdrops. The
>problem arises when you have more backdrop layers.
>
>Hope that I'm making sense here. Can you use the NOT function to exclude
>objects because I definitely have never used it successfully.
>
>I hope that someone can help. Thank you.
>
>Litea
>----------------------------------------------------------------------
>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]
