Listers, I am working on a couple of approaches to this problem but I'd like to see if anyone out there has a solution to this. I have two tables Roads.Tab and Sites.Tab. Each link of the road has an ID and each site has an ID.
I would like to output a file that tells me for each link which sites are within 1km. It would read something like: Link Site 1 23 1 47 1 100 2 1 2 4 3 560 4 57 4 48 4 900 I think I have to query each link, one at a time, i.e. create a buffer, find out what's inside, write the info out, dump the buffer, move to the next link. However, I really need a quick solution! Can anyone make a contribution? Can I write a fancy query for this or do I need to write some code? Thanks. Dave This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 11697
