Hi,
Make a copy of your table and run this SQL statement
Select * From ORIGINAL, COPY
Where ORIGINAL.OBJ Intersects COPY.OBJ
And ORIGINAL.VALUE <> COPY.VALUE
HTH,
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
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, February 15, 2006 1:48 AM
To: mapinfo-l@lists.directionsmag.com
Subject: [MI-L] Selecting intersecting polylines with differen attribute
Hi all,
Question: how to write a query which selects all intersecting polylines having
one different attribute?
select * from T1 where (obj intersects obj) and ( z <> z) doesn't work
Hymmm....
Thanks & Regards,
Kaz Becek
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
_______________________________________________
MapInfo-L mailing list
MapInfo-L@lists.directionsmag.com
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
