Hi - I wonder if any can advise me on the following issue?

I need to run two active databases (e.g. This1.db and This2.db)

I want to do an SQL SELECT operation on (say) Table 1 in This1.db and
on (say) Table 2 in This2.db). I want to produce a DW report with the
data selected from both tables, arising from two seperate databases.

Can this be done?

It seems to be that this operation can only be done by:

a) first get the relevant data from Table 1 - by accessing This1.db.
Save this accessed data in a temporary file.

b) SELECT from the temporary file and Table2 in This2.db.

I have come to this conclusion since there seems no way to select an
SQL connection to two databases in the same statement.

Any comments?

Many thanks,

Alastair Walker

I am using ASA 9.0.2.3044 with PB Professional 10.5 Build 4523.

Alastair Walker wrote:

It is what remote servers and proxy tables are for. BTW, ASA manual has
an entire chapter (Accessing Remote Data) about the topic.

Dmitri.

Many thanks for pointing me in the right direction. It is appreciated!

Regards,

Alastair Walker

On 25 Jan 2010 01:20:16 -0800, Dmitri <NOdimSPAM (AT) mail15 (DOT) com> wrote: