CREATE VIEW dbo.view_report_mrecords
AS
select a.*,
b.search_no
from a
left join
( select * from openrowset
('SQLOLEDB','10.3.8.6';'user';'123',purchase.dbo.output_warehouse)
) as b on a.outwarehouseid = b.id
用了yyoinge大哥的方法从远程数据源提取数据 CREATE VIEW dbo.view_report_mrecords AS select a.*, b.search_no from a left join (select * from openrowset ('SQLOLEDB','10.3.8.6';'user';'123',purchase.dbo.output_warehouse) ) as b on a.outwarehouseid = b.id 数据库是sql2000,表a是当