Hello all. I have a list of outlets in one table and a list of particular location points in another. I'm trying to determine which of my outlets fall within 1 mile of each of these locations AND identify which location it is. I tried drawing 1 mile buffers around each of my locations, updating a column in my buffer table with the ID from the location table (using 'Join where object from LocationTable is within object from BufferTable) and then using a SQL select query to pull off the outlets. However, although this worked very well for most locations, it allocated the wrong ID where there was more than one Location within a particular buffer. Can anyone tell me how to get round this problem please? By the way, I am very new to MapInfo, so please make all replies very simple to understand. Thanks loads, Gillian [EMAIL PROTECTED] _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.