select query for three joined table?

Question

hi friends
i have three table in access 2010 joined with each other

table one
a1 number pk
b1 text
c1 text

table two
a2 number pk
b2 text
a1 number fk

table three
a3 number pk
b3 text pk
a1 number fk

know i want to make query that select (a1,b1,b2,a3,b3) with where condition for (a1= anything) ... how i do this please help me?

Javeed M Shaikh · Answer

not sure if this is what you are looking for: select a.a1a.b1b.b2c.a3c.b3 from tableone a tabletwo b tablethree c where a.a1=123 and a.a1 = b.a1 and a.a1 = c.a1 ;