Union then apply
=ACOS(COS(RADIANS(90-Lat1)) *COS(RADIANS(90-Lat2)) +SIN(RADIANS(90-Lat1)) *SIN(RADIANS(90-Lat2)) *COS(RADIANS(Long1-Long2))) *6371 for km, convert to mile, if CF[distance] less than 1 mile boolean filter.
You can also use geospatial functions if databases support them.
If you scroll down to the last section about Scalar functions in this article
I gave an example as that shows how to do a perimeter search for customers within a certain range of selected store.