Multiple databases query? NEED HELP

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 Received on Sat Jul 10 1999 - 09:39:33 CDT