RE: MI Duplicates in query

[Martin Roundill]

Hi Jennifer,   Without seeing your code it is difficult to know what your problem is.   I find I can get rid of the duplicates by adding the the 'any' clause to the sql code.  This stops the object being selected more than once if it is in multiple regions.   eg    select * from store_locations where object within any (select * from my_zip_bdy [where .....] )     Alternatively you could use the update column command to append the zip code to the point (either as a temporary column or a permanent one) and then select those points  that have the correct code - this is more cumbersome if you have lots of zips area to work with.   Good luck   Martin   ================================== Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -----Original Message----- From: jennifer kearney [mailto:[EMAIL PROTECTED]] Sent: Monday, 7 February 2000 12:36 To: [EMAIL PROTECTED] Subject: MI Duplicates in query I need help!  Perhaps its just one of those Sundays when the brain doesn't function properly, but, I am running an SQL query with a point file of store locations and a zip boundary file of a coverage area.  I just have to find the store locations within the zip boundaries.  I've done this many times before, but this time I'm coming up with lots of duplicates in my resulting table.  Any ideas? Thanks, Jennifer Kearney