gojets1721
Registered User.
- Local time
- Today, 00:43
- Joined
- Jun 11, 2019
- Messages
- 430
I have retail stores with a database that tracks events from the locations.
I have two tables:
Table 1: houses all the events and the data associated (location, date, description, etc.)
Table 2: houses each location with the corresponding manager
I'd like to create a query that links the two tables. Basically it'd have all the same columns from Table 1, plus a managers column based on the info in Table 2. Hypothetically, the correct manager would populate based on the location. I just don't know how to actually link this.
Doing this would save me precious time, as there's thousands of entries in Table 1 and it'd take forever to manually add the manager to each entry.
Please help. Thanks
I have two tables:
Table 1: houses all the events and the data associated (location, date, description, etc.)
Table 2: houses each location with the corresponding manager
I'd like to create a query that links the two tables. Basically it'd have all the same columns from Table 1, plus a managers column based on the info in Table 2. Hypothetically, the correct manager would populate based on the location. I just don't know how to actually link this.
Doing this would save me precious time, as there's thousands of entries in Table 1 and it'd take forever to manually add the manager to each entry.
Please help. Thanks