Merge datasets

[Sofia2022]

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?

[Quentin]

It looks like you could use the MERGE statement.  What code have to tried?  Did you get an error, or wrong result?