sql1 = "SELECT Nr, Name, Vorname FROM TABELLE1 WHERE AKTIV = True;"
sql2 = "SELECT Nr, YYYYMM, Info FROM TABELLE2 WHERE YYYYMM = 200705;"
 
SET ABFRAGE = CurrentDb.OpenRecordset("SELECT * FROM " & sql1 & " LEFT JOIN " & _
  sql2 & ";")