Hi, We're having an interesting problem; We're working with two tables, Table A is a list of outlets Table B is a list of competitors' outlets Both tables have Lat/Lon in there. We already have the distance formulas. What we want to do is: For each outlet in Table A, select 7 nearest competitors' outlets from Table B to the outlet in Table A and output the result. Continue the same for next outlet in Table A. Any suggestions on how to achieve it? Thanks in advance. -- Erick Posner -- Free Stuff from Cyberrebate! http://www.csun.edu/~eposner/cyberrebate.html _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com _______________________________________________________________________ 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.