New column in table that populates based on another table

Hi everyone,   I'll try to be as clear as possible:   I'm working on some data in which each observation is a single transaction ID (about 30000 observations). There's variables for location (pro...