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 Data from 2 Databases on Same Server?

Author  Topic  mj Starting Member 25 Posts Posted - 2001-08-30 : 09:10:17 I would like to know if it is possible to do a join on related records contained in 2 different databases on the same SQL Server. My problem lies in the fact that the company I am doing work for has several different databases that share common data, instead of one large database with a whole bunch of tables. I was wondering if it is possible to do something like Select dbname1.tablename.fieldname from dbname1.tablename inner join dbname2.tablename where dbname1.tablename.fieldname = dbname2.tablename.fieldname If this is not possible, does any one have any ideas for a possible work around. thanks in advance mj