Join tables on multiple fields (SQL)

[Steppenwolf]

Is there any way to join two tables via sql based on two fields?
If I have the two tables
T1 (F11,F12,F13) and T2(F21,F22,F23) and would like to get a recordset in MS SQL showing e.g. F13 and F23 for all entries where (F11 and F21) AND (F12 and F22) are matching, how would I do that?

 

[JABE]

Sure. Try:

SELECT T1.F13, T2.F23 FROM T1
INNER JOIN T2
ON T1.F11 = T2.F21 AND T1.F12 = T2.F22