query on multiple database

gld88

in two database ,i want to select some columns of three tables each of two databases where column name is same

BHTanna

All databases on same server?

ck9663

use the fullname of the object

Expand|Select|Wrap|Line Numbers

 SELECT ....FROM db.owner.yourtable

.....LEFT JOIN anotherdb.owner.yourtable

If they're on a different server, you might need to link those server first.

-- CK

gld88

Quote:

Originally Posted by BHTanna

All databases on same server?

yes all database in same server , are you give me some solution
thanks

re: query on multiple database