Hi David, Sure, it is doable. It's just a question of putting the words in the right order ;-) And I also think that you need to use a subselect for this query:
Select * From ONETABLE Where Not OBJ Within Any (Select Obj From SECONDTABLE) Note that I have placed the Not in front of the condition. This means that MapInfo will start testing the condition, and if the condition is TRUE, it will end up being FALSE; if the condition is FALSE it will end up being TRUE But again, I will have to tell you that this query is slow (I'm actually not sure whether this was what they fixed with the patch for MapInfo 8.0??), so if speed is important, I would recommand you to leave out the NOT and use the Invert selection afterwards Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis COWI har fået ny hjemmeside. Ydelserne GIS og IT, kort, kortlægning, 3D visualisering og arealforvaltning ligger under SAMFUND. Se mere her : www.cowi.dk COWI has changed its homepage. Our services within cadastre and landadministration, geodataproducts, mapping and GIS can be seen under SOCIETY. See our services here: www.cowi.com -----Original Message----- From: David Reid [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 05, 2005 11:23 PM To: 'MapInfo-L (E-mail)' Subject: MI-L SQL WITHIN operator question Greetings All, Objects in one table = text objects some line objects Objects in second table = region/polyg objects Attempting to select objects in one table that are "Not Within" objects of a second table. [MYTEXT].Obj Within [MYINSETS].Obj Naturally selects all the text objects that are found within the polygon objects. Is "Not Within" simply not doable? Ex: [MYTEXT].Obj Not Within [MYINSETS].Obj Aside from selecting all objects that "Are Within", then using the Inverse select tool, just isn't pretty :) Thanks, David Reid -- Outgoing mail is certified Virus Free Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.11.10/119 - Release Date: 10/04/2005 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 18144
