Hi Sasidhar, The following query will provide a list of buildings with no duplicates: select * from buildings, consumers where buildings.obj contains consumers.obj group by buildings.ID
(Substitute the 'ID' field for the field in your table that uniquely identifies the building.) The 'group by' clause eliminates the duplicates, but also leaves out the graphic objects. This is fine if all you want is a list of buildings, but if you want your query to retain the graphic objects, you may need to try something a little trickier: select * from buildings where buildings.ID in (select buildings.ID from buildings, consumers where buildings.obj contains consumers.obj) Cheers, Simon __________________________________ Simon O'Keefe GIS & Mapping Specialist Groundtruth mobile: +61 409 413 890 office: +61 3 5345 3966 mail: PO Box 290 Clunes VIC 3370 Australia __________________________________ --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 17370
