将信息从一个表应用到同一数据库中的单独表？

Question

I have TABLE 1 that contains zip codes and their location information (i.e longitude, latitude, etc), TABLE 2 contains the properties with their addresses... I need to connect the longitude and latitude of the zipcodes in the TABLE 1 to the addresses in TABLE 2 >>

to be able to create a search that gives the nearest properties in a (x)mile radius of a specific zip code...

I'm not sure how to do this. Do I need to combine the two tables? Or can I do a search that pulls info from both simultaneously?

Thanks!

Answer 1

First of all, you need to build relatinship between these two tables, you can use Zipcode, or you can use surrogate key. Then you can join the two table to do search.