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