Table 1
Postcode | Town | Region |
7000 | Town1 | Region1 |
7000 | Town2 | Region1 |
7100 | Town3 | Region1 |
7120 | Town4 | Region2 |
7121 | Town5 | Region3 |
7121 | Town6 | Region3 |
Table 2
ClientID | Postcode | Postcode |
1 | 7000 | Town1 |
2 | 7000 | Town2 |
3 | 7121 | Town5 |
4 | 7121 | Town5 |
5 | 7100 | Town3 |
6 | 7101 | Town7 |
I want to merge table 2 with table 1 to identify which regions the patients are from through Postcode and Town columns. Please note different towns could have the same postcode. How should I do this?