what's the equal word for "join on " from sql for access , using in query about jo

[arash]

Hi what's the equal word for "join on " from sql for access , using in query about joining tables.
thanks

[r937]

the same as other databases

except that in access, the keyword INNER is not optional

select foo
     , bar  
     , qux
  from table1 
inner 
  join table2
    on table1.id = table2.id1