比如
select * from  database1.dbo.table
union all 
select * from database2.dbo.table

------解决方案--------------------
USE MASTER
GO
SELECT users.uid,userstype.typename,users.name FROM database1.dbo.users users,
database2.dbo.userstype userstype
WHERE userstype.usertypeid = users.usertypeid  
[dbo]为SCHEMA名

远程数据库可以通过链接服务器加载过来

------解决方案--------------------
支持5楼！

------解决方案--------------------
探讨

USE MASTER
GO
SELECT users.uid,userstype.typename,users.name FROM database1.dbo.users users,
database2.dbo.userstype userstype
WHERE userstype.usertypeid = users.usertypeid 
[dbo]为SCHEMA名

远程数据……