I have a table with a of 200 stores (Table A) and their lat longs and another group of 1600 stores (Table B) with their lat longs. How in a sql statement would I find distance from all the stores in Table A to Table B. I can figure out how to do it from a specific store lat/long i.e. -71.2555, 42.15222 to the centroidX(obj) Centroidy(obj) "mi" but can not figure out how to get more than one store in a one step batch. Any suggestions. Should look like: Table A Store #1.....Table B Store #1...1.1 mi Table A Store #1.....Table B Store #2...1.3 mi Table A Store #1.....Table B Store #3...1.5 mi Table A Store #1.....Table B Store #4...2.4 mi Table A Store #2.....Table B Store #1...5.8 mi Table A Store #2.....Table B Store #2...7.1 mi Table A Store #2.....Table B Store #3...10.8 mi Table A Store #2.....Table B Store #4...15.7 mi
begin:vcard n:Ormond;Christian tel;fax:508-894-7511 tel;work:508-894-7584 x-mozilla-html:FALSE url:www.shaws.com org:Shaw's Supermarkets Inc;Market Research adr:;;120 Liberty St;Brockton;MA;02301-5521;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Sr. Site Location Anlayst end:vcard