Mutiple join query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eseosa Omoregie - 09 Nov 2005 15:54 GMT

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?

Signature

Eseosa Omoregie
Database manager

Reply to this Message

[MVP] S.Clark - 09 Nov 2005 17:36 GMT

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.

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting

>I have 4 tables in my database. I perform a series of joins to end up with
>a
[quoted text clipped - 5 lines]
> of
> joins and produce the final table?

Reply to this Message

John Vinson - 09 Nov 2005 18:10 GMT

>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?

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]

Reply to this Message