honar abubakr

honar abubakr

  • NA
  • 73
  • 110.3k

select query for three joined table?

Sep 5 2013 11:21 AM
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?

Answers (1)