This is really my #1 on the wishlist....

On Tue, 15 Feb 2005 14:18:38 +1100, Helen Borrie wrote:

>
>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
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>