How can I create a relationship between these two tables?

Create a third query. Use one of your sources that has all the Names that you need and remove all other columns. Remove duplicates. Use this table to relate to each of the other tables. This is a bridge table. You will have to be somewhat careful with this as if you have information from both linked tables in the same visual it can cause problems unless you aggregate values from one of the tables. But, that is the general idea.