Hi Eric,
try
select * from File1 where not object intersects any (select object from
File2) into MyTable
Anyone know of a quicker way to do this in SQL ?
Cheers
Martin
==================================
Martin Roundill
GIS Manager
Waitakere City Council
Private Bag 93109
Henderson
Waitakere City
New Zealand
-----Original Message-----
From: Eric Bonte [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 9 February 2000 01:42
To: MAPINFO Mailing List
Subject: MI Geographic Operators
Hello mappers,
I try to write a SQL selection, like :
Select * from File1, File2 where File1.Obj Not Intersects File2.Obj into
Selection
But "not intersects" is unknown in mapinfo, how to do ?
Any suggestion ?
Thanks,
--
Eric BONTE
____________________________________________________________
AUCHAN
Service Marketing - Département Etudes & Prospectives
200, Rue de la Recherche
59650 Villeneuve d'Ascq (FRANCE)
Email : [EMAIL PROTECTED]
Tel : +33 3 28 37 66 24
Fax : +33 3 28 37 63 22
----------------------------------------------------------------------
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]