view_countInfo
来源:互联网 发布:智能编程机器人 编辑:程序博客网 时间:2024/05/02 19:06
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
0 0