SQL join with composite primary key

You can use AND in the expression for the ON criteria and demand the fields are all equal there.

SELECT * 
FROM Table1
INNER JOIN Table2
ON Table1.Key1 = Table2.Key1 AND Table1.Key2 = Table2.Key2 AND Table1.Key3 = Table2.Key3