Generate same key in different tables based on 2 fields
Table1 has fields T1.FieldA, T1.FieldB, Count1
Table2 has fields T2.FieldA, T2.FieldB, Count2
I need to keep the tables separate because I don't want the counts to inflate, but how do I join the two tables on fields A and B?
I could create a link table, but I would prefer to make a compound key. Since one of these fields is text, I was wondering if there is some function that will translate the combined FieldA+FieldB to the exact same integer in both tables.