sql question 1

[FOXPROG]

I have two tables in an access database I need to select records in table1 based on information in table2. Table1 has a common field in table2. I want to get all the records in table1 that match table2.id2 when table1.id = table2.id
See example below.

table1
id first last

talbe2
id id2

 

[Ray1127]

Select table1.*
from table1 inner join table2 on table1.id = table2.id2