Creating a SNAP that will assign a value to each record in a dataset by referencing a table of 40,000 values

I have a live dataset of locations that includes the zip code of each individual location. I have a separate table that contains the 40k+ different zip codes in the US, along with what time zone tha...