Multiple Table Query

  • Thread starter Thread starter Inferno
  • Start date Start date
I

Inferno

Hello all,

Basically I have four db's that have completely different information,
except dates and mundane stuff, that need to either be imported into a
single db, or just queried at the same time for reporting purposes.

Any suggestions would be great. I know it is a simple answer, it is
just escaping me recently.

Thanks.
 
do you mean databases or tables?
if you mean tables you need to know how the tables are related i.e. what
columns in each table refer to columns in the other tables.
You will code a query joining the tables on the columns you have identified.
What type of joins you need depends on the data.
Until you can answer these questions, you can't proceed.

- Dorian
 
Back
Top