Join properties question

[happyhungarian]

Hi, I was wondering if something was possible within Access queries. I wanted to join a field with one table to two possible fields in another table. Essentially the value in field "A" in Table1 could be found in field "A" or "B" in Table2. Table 1 has my list of unique values that I want to pull. What type of join would I have to do if this were possible?

Thanks,

Jesse

 

[Joe4]

Typically, you would add Table 2 twice, and have two separate joins (one for each field).