不同服务器不同库的不同表间的join

select * from (
select  b.pid,b.cmcuser,b.gameusername,b.opertime,u.tel,u.mobile 
from  CMC_SUB1.dbo.BindRelation_2 as b 
inner join CMC_SUB2.dbo.UserInfoAll as u on b.pid=u.pid) s
inner join (select pid,truename from openrowset('SQLOLEDB','服务器地址';'登录名';'密码',CMC.dbo.VIEW_UserTrueInfoGather)) c on s.pid=c.pid

转载于:https://www.cnblogs.com/iammrwu/archive/2012/08/02/2619573.html