Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 joining tables on different databases

Author  Topic 

raj70
Starting Member

2 Posts

Posted - 2004-10-08 : 02:08:47
My tables are located on two different databases
and stored procedure reside with one of the tables
The sqlserver is the same.
What is the easiest and efficient way to write a query
using joins to fetch data from both the tables.

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2004-10-08 : 02:17:23
use a 3 part naming convention like this :

INNER JOIN northwind.dbo.customers

See more here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=41015


Damian
Go to Top of Page
   

- Advertisement -