Query to 2 databases
A query pulls from a table in one database. A value pulled is an id for a record in another database table. The id is an employee number. I want to get the employee's name based on that id from the employee table in a different database. I can access both dbs no problem. Can I somehow write the query so that it will go to the second db table and get the full name based on the id? Can I do this all in one query or do I have to loop thru the results and run another query to get the names?
Subject
Written By
Posted
Query to 2 databases
June 04, 2021 07:24AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.