create view view_countInfo as
SELECT a.dwmch, b.dwbh, b.djbh, c.rq, c.shl, c.djbh AS Expr1, d.spid, d.spbh, d.spmch
FROM ksoa.dbo.mchk AS a INNER JOIN
ksoa.dbo.pf_ckhz AS b ON a.dwbh = b.dwbh INNER JOIN
ksoa.dbo.pf_ckmx AS c ON b.djbh = c.djbh INNER JOIN
ksoa.dbo.spkfk AS d ON c.spid = d.spid
SELECT a.dwmch, b.dwbh, b.djbh, c.rq, c.shl, c.djbh AS Expr1, d.spid, d.spbh, d.spmch
FROM ksoa.dbo.mchk AS a INNER JOIN
ksoa.dbo.pf_ckhz AS b ON a.dwbh = b.dwbh INNER JOIN
ksoa.dbo.pf_ckmx AS c ON b.djbh = c.djbh INNER JOIN
ksoa.dbo.spkfk AS d ON c.spid = d.spid
扫一扫
5646
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
