752
社区成员
发帖
与我相关
我的任务
分享
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