How to write

[abglorie]

How to retrieve data from two different database with single query

[WoutL]

Put the database in teh from clause:

select * from [database].[owner].[tablename]

select * from nortwind.dbo.customers

You can ommit the owner if you want:

select * from northwind..customers

Wout Louwers

[gajendra_kshatriya]

select t1.*,t2.* from database1name.dbo.tablename as t1 join database2name.dbo.tablename as t2 on t1.columnname=t2.columnname where condition (if any)

[Mycroft Holmes]

The responses you have assume that the databases are on the same server, in which case database.owner.tablename will work. If they are on different servers you have a problem, you need to set up linked servers, something I hate doing as the server is then hard coded into the query.

Never underestimate the power of human stupidity RAH