SELECT A.* FROM OPENROWSET('SQLOLEDB','jsproxy';'tz2';'jscpd',
'select a.ass_unino,a.ass_no,a.ass_nm,b.LL_Type,b.Mat_No,c.mat_nm,b.LL_Qty, b.LL_Price,
b.LL_Date,b.LL_Dept,b.LL_Name,b.LL_No,a.syqk_no,a.InFact_date,a.old,d.name
from ass_assetm as a, ZW_LLrb_Ass as b, zw_good as c, rs_dept as d
where a.ass_unino = b.ass_unino
and b.mat_no = c.mat_no
and b.ll_dept = d.deptno
and a.ass_unino = ''JS-0026860'' ') AS A
'select a.ass_unino,a.ass_no,a.ass_nm,b.LL_Type,b.Mat_No,c.mat_nm,b.LL_Qty, b.LL_Price,
b.LL_Date,b.LL_Dept,b.LL_Name,b.LL_No,a.syqk_no,a.InFact_date,a.old,d.name
from ass_assetm as a, ZW_LLrb_Ass as b, zw_good as c, rs_dept as d
where a.ass_unino = b.ass_unino
and b.mat_no = c.mat_no
and b.ll_dept = d.deptno
and a.ass_unino = ''JS-0026860'' ') AS A
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货