I think this is what you want:- Select * from <objects table> where obj intersects (select obj from <streets table> where ID_STREET = 13)
Regards, Keith -----Original Message----- From: Jorge Cordero [mailto:[EMAIL PROTECTED] Sent: 26 February 2004 22:39 To: [EMAIL PROTECTED] Subject: MI-L INTERSECTS OBJECTS Hello Listers I need from your help to create a query to a table of streets that are objects of type polyline. I want to obtain all the objects that do intersection with objects that ID_STREET = X To Example ID_STREET = 13 Then the objects that intersects is: 13 - 110 13 - 25 13 - 8 13 - 5 Regards TSUI. Jorge Eduardo Cordero Rodriguez This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 10622
