hi,

 i am a beginner so please bear with me...thanks

  i can do a simple join quert on 2 tables eg

   "select id, name, address, payroll_number, pay_scale
    from personnel join payroll on [personnel].id=[payroll].id"

  BUT...
    what if i need to get further information from another
    table ( ie a 3rd table ) and also join on the id field ?

  If this makes sense - could anyone kindly give me a code example
  as i cannot find one in any book. The code examples i have
  only do joins on 2 tables at a time.

  Many thanks for any replies.

  Chas. UK

You can have 3rd join as:

"select id, name, address, payroll_number, pay_scale
    from personnel join payroll on [personnel].id=[payroll].id
     join table3 on table3.id = [payroll].id "



Om Prakash

Hy badgolfer will the third table will be liked to the same primary key as the other table or with another field.

What I mean is, for instance, if the two tables are linked with a CustomerID (primary and foreign key), is the third table also linked to CustomerID or say, for instance, a Projects table?

See what I say? BTW are you using Access to create your query?

There are a few possibilities here:

CustomersTable -> ProjectsTable -> EmployeesTable

Where each Customer has many Projects and each Project uses many Employees. Get it?

CustomersTable -> ProjectsTable
CustomersTable -> EmployeesTable

Where each Customer has many Projects as well as many Employees.

So tell us about your design a little bit.

Daniel