Match on multiple fields without synthetic key

[#1]

Two different tables.  Here is an example...

Table1:

Field1, Field2, Field3

Smith, Bob, Austin

Jones, Sally, San Diego

Table2: (note different field names)

FieldA , FieldB, FieldC

Jones, Bob, Cincinnati

Smith, Sally, San Diego

I'd like to display in a straight table or chart, all records where "Field1=FieldA AND Field2=FieldB AND Field3=FieldC".  There are actually 10 fields that need to match so using a synthetic key is not possible.  I've attempted with Set Analysis but can't seem to get the right combination.  Flexible on the approach but I eventually need to narrow my result set down to the records that meet all of the criteria above and most importantly, I don't want to select the criteria one field at a time.

Thoughts?

[#2]

you can explore indirect set analysis.

Field1=..... p(FieldA)

[#3]

Can you elaborate please?  I tried this approach but it gave me ALL possible values of FieldA and not the ones that matched Field1.  So it was ...

Field1=Jones, FieldA=Jones, FieldA=Smith

I need only ... Field1=Jones,FieldA=Jones

[#4]

Have a look at this discussion, that should give you a good idea.

How to compare 2 fields using SET ANALYSIS ?

[#5]

Thanks but I found the same discussion earlier and it didn't help.  The correct answer was never identified and he is having the exact same problem I am still.  I'm posting here as a last resort from not being able to locate a solution on my own.

Again, I need a 1 to 1 match on multiple fields across two tables ...

Field1 = FieldA AND Field2 = FieldB AND Field3 = FieldC