I have two tables.

In one of the tables is going to be a key field that is not really a key.

Example:

Table 1 Table 2
1. charge ABC cost 1. ABC
2. expense CBD is good 2. CBD


3. savings 102343 3. 102343

the first table comes to me that way, there's nothing i can do about it. The second table is what i'm building. There is a 3rd table that is not very important at this point that's going to be linked to the second table but what i'm trying to do is link table 1 to table 2 through the key's above. I do not have any other keys, this is as unique as it's going to get. I realize this is an aweful process but this is what i'm stuck with. what i'm trying to do is join on (Like (Table1)) to Table2. Does anyone know how to do that? If it's possible? VBa or SQL?

Thanks in advance,
Alex