跨引擎库查询

select a.* from openrowset('SQLOLEDB','192.168.1.1\Sqlexpress';'sa';'123456','select  * from temp.dbo.Act as a where a.actid in(11,22,33,33) roder by id') a  inner join dbo.newtemp b on b.id=a.id