Problems with Merging two tables by UK Post Code

Good Morning. As the data I am working with is confidential patient information I am prohibited from uploading any of the files but I hope these three images will help demonstrate the problem

I have looked everywhere but cant seem to find the solution so I am hoping someone on the forum can help me