不同服务器不同库的不同表间的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