Help Multiple Operators in INNER JOIN

[rando1000]

I've got a query from SQL Server that I'm trying to carry over to Access. The Query uses 3 tables with two INNER JOINS, and each of the INNER JOINS has two operators, roughly like this:

 Select Table1.Field1, Table1.Field2
FROM Table1 INNER JOIN Table2
  ON Table2.Key1 = Table1.Key1
 AND Table2.Key2 = Table1.Key2
 AND Table2.Key3 = Table1.Key3 INNER JOIN Table3
  ON Table3.Key1 = Table2.Key1
 AND Table3.Key3 = Table2.Key3
 AND Table2.Key2 = Table3.Key4

This gives me Operator errors after the first AND clause in the first INNER JOIN.

[rando1000]

Never mind. I figured it out using the design view. Seems you need to nest one of the INNER JOINS in the FROM statement and then join that to the other table.