You need to separate the criteria in the WHERE clause Select * from table1, table2 WHERE table1.obj within table2.obj and table1.id = [some value here] and table2.id = [some value here]
Ben Greenberg GIS Coordinator NAI MLG Commercial 262-797-9400 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Véronique De Laet Sent: Friday, June 09, 2006 6:04 AM To: mapinfo-l@lists.directionsmag.com Subject: [MI-L] sql dear list, I want to select polygones with a specific ID from one table which lay within polygones with a specific ID in another table? Is there someone who knows how to do this? I used the querry sql select function and indicated under from tables the two tables next under the where condition I indicated table1.column 1=ID Within table2.comumn1= ID But This does not seem to work. thanks, Véronique -- NOTE NEW ADDRESS AND TEL.! Véronique De Laet Physical and Regional Geography Research Group, K.U.Leuven GEO-INSTITUTE, Room 03.212 Celestijnenlaan 200 E, B-3001 Heverlee, Belgium Tel : +32 16 32 64 13 / 016 32 64 33 Fax : +32 16 32 29 80 [EMAIL PROTECTED] http://www.kuleuven.be/geografie/ http://www.sagalassos.be Disclaimer: http://www.kuleuven.be/cwis/email_disclaimer.htm _______________________________________________ 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