prtvu xsdabljc 视图代码
SELECT dbo.xsb.Xh AS xhjm, dbo.xxdmb.Xxdm AS dwdm, dbo.xxdmb.Xxmc AS dwmc,
dbo.bjxxb.Bmc, dbo.xslbdmb.Xslbmc, dbo.xsjbqkb.Sfzh, dbo.xbdmb.Xbmc,
dbo.mzdmb.Mzmc, dbo.xjztdmb.Xjztmc, dbo.xslbdmb.Xslbdm, dbo.zydmb.Zymc,
dbo.xsb.Zydm, dbo.xsb.Gzh, dbo.xsjbqkb.yddh AS dh, dbo.xsb.Xm, dbo.xsb.Xxdm,
dbo.xsb.Bdm, dbo.xsb.Xslxdm, dbo.xsb.Xjztdm, dbo.xsjbqkb.Gzdw AS dwdz,
dbo.xsb.Nd AS nj, dbo.xsb.Zygzxq AS zsjj, dbo.xsjbqkb.Whcddm,
dbo.whcddmb.Whcdmc, dbo.xqdmb.Xqmc, dbo.xsb.Xh
FROM dbo.bjxxb INNER JOIN
dbo.xxdmb ON dbo.bjxxb.Xxdm = dbo.xxdmb.Xxdm INNER JOIN
dbo.xsb ON dbo.bjxxb.Bdm = dbo.xsb.Bdm INNER JOIN
dbo.xsjbqkb ON dbo.xsb.Xh = dbo.xsjbqkb.Xh INNER JOIN
dbo.xslbdmb ON dbo.bjxxb.Xslbdm = dbo.xslbdmb.Xslbdm INNER JOIN
dbo.xbdmb ON dbo.xsjbqkb.Xbdm = dbo.xbdmb.Xbdm INNER JOIN
dbo.xjztdmb ON dbo.xsb.Xjztdm = dbo.xjztdmb.Xjztdm INNER JOIN
dbo.zydmb ON dbo.bjxxb.Zydm = dbo.zydmb.Zydm INNER JOIN
dbo.whcddmb ON dbo.xsjbqkb.Whcddm = dbo.whcddmb.Whcddm INNER JOIN
dbo.xqdmb ON dbo.xsb.Xqdm = dbo.xqdmb.Xqdm LEFT OUTER JOIN
dbo.mzdmb ON dbo.xsjbqkb.Mzdm = dbo.mzdmb.Mzdm
SELECT dbo.xsb.Xh AS xhjm, dbo.xxdmb.Xxdm AS dwdm, dbo.xxdmb.Xxmc AS dwmc,
dbo.bjxxb.Bmc, dbo.xslbdmb.Xslbmc, dbo.xsjbqkb.Sfzh, dbo.xbdmb.Xbmc,
dbo.mzdmb.Mzmc, dbo.xjztdmb.Xjztmc, dbo.xslbdmb.Xslbdm, dbo.zydmb.Zymc,
dbo.xsb.Zydm, dbo.xsb.Gzh, dbo.xsjbqkb.yddh AS dh, dbo.xsb.Xm, dbo.xsb.Xxdm,
dbo.xsb.Bdm, dbo.xsb.Xslxdm, dbo.xsb.Xjztdm, dbo.xsjbqkb.Gzdw AS dwdz,
dbo.xsb.Nd AS nj, dbo.xsb.Zygzxq AS zsjj, dbo.xsjbqkb.Whcddm,
dbo.whcddmb.Whcdmc, dbo.xqdmb.Xqmc, dbo.xsb.Xh
FROM dbo.bjxxb INNER JOIN
dbo.xxdmb ON dbo.bjxxb.Xxdm = dbo.xxdmb.Xxdm INNER JOIN
dbo.xsb ON dbo.bjxxb.Bdm = dbo.xsb.Bdm INNER JOIN
dbo.xsjbqkb ON dbo.xsb.Xh = dbo.xsjbqkb.Xh INNER JOIN
dbo.xslbdmb ON dbo.bjxxb.Xslbdm = dbo.xslbdmb.Xslbdm INNER JOIN
dbo.xbdmb ON dbo.xsjbqkb.Xbdm = dbo.xbdmb.Xbdm INNER JOIN
dbo.xjztdmb ON dbo.xsb.Xjztdm = dbo.xjztdmb.Xjztdm INNER JOIN
dbo.zydmb ON dbo.bjxxb.Zydm = dbo.zydmb.Zydm INNER JOIN
dbo.whcddmb ON dbo.xsjbqkb.Whcddm = dbo.whcddmb.Whcddm INNER JOIN
dbo.xqdmb ON dbo.xsb.Xqdm = dbo.xqdmb.Xqdm LEFT OUTER JOIN
dbo.mzdmb ON dbo.xsjbqkb.Mzdm = dbo.mzdmb.Mzdm