One Join with 2 Criteria

J

James

Hi

I have a table that I am trying to Join to a second table but with the Join
defined by 2 criteria. ie I have 2 fields in table one that must Join with 2
fields in table 2.

Table1.AccID = Table2.AccID AND Table1.transactionType =
Table2.transactionType.

Can this be done?
 
Top