[namitao]

Hi
I want to run a SQL query on count.
I have a 2 files one is an alcohol outlet and other is convenience stores. I want to check how many alcohol outlets at 0.5 mile radius are there around the stores, say . ex there are 3 alcohol outlets in 0.5 mile radius of a stores A, how do i get the number
thanks for the help

[andrewst]

Originally posted by namitao
Hi
I want to run a SQL query on count.
I have a 2 files one is an alcohol outlet and other is convenience stores. I want to check how many alcohol outlets at 0.5 mile radius are there around the stores, say . ex there are 3 alcohol outlets in 0.5 mile radius of a stores A, how do i get the number
thanks for the help

Distance between 2 points (x1,y1) and (x2,y2) is SQRT( (x2-x1)*(x2-x1) + (y2-y1)*(y2-y1) )

[acg_ray]

Do you have the longitude and latitude of each store from each file? You would need that piece of information in order to calculate the distances between two points on a sphere (such as the earth).