Multiple Table Query

[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.

 

[Inferno]

I figured it out... rack this one up to a brain fart.

 

[mscertified]

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