本文介绍了一个SQL脚本，用于创建名为view_countInfo的视图。该视图通过连接多个表来汇总信息，包括mchk、pf_ckhz、pf_ckmx和spkfk表。这些表的数据被整合以提供详细的产品和交易记录。
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
扫一扫
1110
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
