Re: Multiple databases query? NEED HELP

Try Cerebellum 1.2 product review at
 http://www.visionsystems.com/products/index.shtml

There is a free demo available.

Hope that helps.

--
Josue Batista
ABC Tech Solutions
http://www.abcsolutions.org
[Java/Oracle/Linux] [C/S & Internet Database Apps]


Phillip H wrote in message <7m7p3l$noo$1_at_news1.mpx.com.au>...


>Hi All,


>

>I am doing a thesis that query against at least two databases. These

>databases are heterogeneous. It may include Oracle, Microsoft Access,

>Microsoft SQL and DB2. A  single query will involve at least two tables

that


>can be in same or different databases.


>

>For example, Payroll data is stored in an Oracle DB, while staff task data

>is in an Access DB. Now I want to retrieve all staff's current salary and

>current task list by a single SELECT statement (syntax may vary):

>

>    SELECT name, salary, task

>    FROM current_salary cs, current_tasks ct

>    WHERE cs.name = ct.name;

>

>The purpose is to hide the details of data distribution. I implement it

with


>Developer 2000. Any ideas on how to do it are appropriated. Are there any


>books or web sites helpful?

>

>Thanks in advanced.

>

>Phillip

>

>