Mutiple join query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have 4 tables in my database. I perform a series of joins to end up with a
table which is my finished product. For example i join 2 tables together to
make another table. Then join this table to another table and so forth. Is
there anyway that I cane perform all my joins in one go. Maybe have a
switchboard with a button which, once pressed will perfoem all the series of
joins and produce the final table?
 
You can add as many joins to a single query, as is logically possible. Add
all of the tables, and create all of the joins.

Multiple queries can be executed with a macro or VBA using the
Docmd.OpenQuery method.
 
I have 4 tables in my database. I perform a series of joins to end up with a
table which is my finished product. For example i join 2 tables together to
make another table. Then join this table to another table and so forth. Is
there anyway that I cane perform all my joins in one go. Maybe have a
switchboard with a button which, once pressed will perfoem all the series of
joins and produce the final table?
Click to expand...

Are you actually creating a new TABLE, storing the data from your
existing four tables redundantly? Why would you want to do so?

A Query can join an almost unlimited number of tables into a dynamic
recordset (which can be used as if it were a table, though a
four-table join will probably not be updateable). Simply add the
tables to the query design grid or to the SQL statement with
appropriate joins.

John W. Vinson[MVP]
 
Back
Top