Error: this could be because there is missing intermediate data to connect the two columns

I have two tables. they both have a column with the same name. And the values in these two columns are the same. When I tried to link these two columns together I got an error: this could be because ...