At 10:59 AM 15/02/2005 +1100, you wrote:

>Hi,
> Is it possible to create a query from more than 1 database? I just
> want to produce views / reports from 2 or more databases (with the same
> structure) without having to import data into a "master" - is this possible?

If you mean - can you form a single set from tables in different databases?
---No.

If you mean -- can your application connect to two (or more) databases in a
single transaction and read data from each? --- Yes.

So - what you want is a report tool that can mess about with multiple
sets; or some kind of "permanent-temporary" table in one of the databases
into which your application code can write data read from the multiple
sets. I guess the latter is what you had in mind as "importing data into a
master". But it's not really "importing", it's more like pumping, since
both sets are in the same transaction context and don't go via any external
file or memory structure.

./heLen