Merge doesn't work but relationship works

Hello I have 1000+ rows of data in table A and wanted to merge table B to it; however, the merged column is empty (no data when I try to filter it). However, if I create a relationship between table...