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

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]

All databases on same server?

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