Home » RDBMS Server » Server Administration » querying 2 databases using sql
querying 2 databases using sql [message #374423] Mon, 11 June 2001 10:12 Go to next message
scueto
Messages: 2
Registered: June 2001
Junior Member
What is the syntax for querying tables in 2 different databases together using SQL queries. Is this possible?

scueto

Report message to a moderator

Re: querying 2 databases using sql [message #374427 is a reply to message #374423] Mon, 11 June 2001 10:55 Go to previous message
Don Tipton
Messages: 3
Registered: April 2001
Junior Member
Try creating a database link to database2 within database1. Then write you query against database 1 and use the dblink to get the needed data from database 2.

Report message to a moderator

Previous Topic: Most qualified match
Next Topic: Most qualified match
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 13:57:18 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.