Joining 2 DB on the same server 2

[Scoty]

I have 2 tables in 2 different DB's on the same server. is it possible to join them through SQL (both DB's belong to the same DBO)

Thanks
Scoty

Learn from others' mistakes. You could not live long enough to make them all yourself
-- Hyman George Rickover (1900-86)

 

[SQLDenis]

yep

select * from db1.dbo.table1 t1 
join db2.dbo.table1 t2
on t1.id =t2.id

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLSister]

sure just use the full name to refernce. Here's an example:

select a.field1, b.f22 from mydatabase..Speakers a join myotherdatabase..TMP00001318 b on a.[field1] = b.f1

Questions about posting. See faq183-874
Click here to help with Hurricane Relief

 

[Scoty]

Thank you very much
Scoty

Learn from others' mistakes. You could not live long enough to make them all yourself
-- Hyman George Rickover (1900-86)