Colin, If you want just the geographic selection and the values from one of the specified tables (this could be the geography id) then you can do it with a single SQL statement.
Select * from Table1 where Table1.obj Contains Entire Any (Select Table3.obj from Table3,Table2 where Table3.obj Contains Entire Table2.obj) into Selection Where Table1,Table2 and Table3 are your tables containing 'mirrored' geography. If you want to compute a 'total' sum value or something like that then a Temp table will be needed. Best Regards, Dave p.s The 'Entire' prefix might not be needed. I can't remember!! --- David P. Langley Director of Programming Services Mapping Solutions, LLC 4660 S. Hagadorn Rd. Suite 120 East Lansing, MI 48823 USA Voice: (+1) 517-332-7735 Cell: (+1) 517-719-6359 Fax: (+1) 517-332-1329 Email: [EMAIL PROTECTED] SMS: 5177196359 (@page.nextel.com) www.mappingsolutions.com --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 9752
