Hi
I am trying to run a spatial query between points and
zip code. After I run the queries the number of point
records increased. The reason this is happening is
because if a point is on the border of 2 zip codes,
the point is shown for both the zip codes. I do not
want it, I want one point for one zipcode.
My query is
Select * from table1 (point), table2 (zipcode) where
Table1.obj within table2.obj
Is there another way to run the query to avoid
duplicate point data?
Thanks
__________________________________
Yahoo! Messenger
Show us what our next emoticon should look like. Join the fun.
http://www.advision.webevents.yahoo.com/emoticontest
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 15937
