学步园

--得到的字段：<br /> --库存记录表所有字段<br /> --直接出库数量（ck_sl）,直接出库重量（ck_zl）<br /> --销售数量(xs_sl)、销售重量(xs_zl)、销售出库数量(xsck_sl)、销售出库重量(xsck_zl)<br /> --已销售未出库数量(xs_ck_sl)、已销售未出库重量(xs_ck_zl)<br /> select * from<br /> tbKuCunJiLuBiao as tbkcjl,<br /> (<br /> select ck_wz.*,xs_wz.xs_sl,xs_wz.xs_zl,xs_wz.xsck_sl,xs_wz.xsck_zl,(isnull(xs_wz.xs_sl,0)-isnull(xs_wz.xsck_sl,0)) as xs_ck_sl,(isnull(xs_wz.xs_zl,0)-isnull(xs_wz.xsck_zl,0)) as xs_ck_zl from<br /> --直接出库<br /> (<br /> select kc.char_KCJLB_SN,sum(ck.float_CKWZJL_YingTiShuLiang) as ck_sl,sum(ck.float_CKWZJL_YingTiZhongLiang) as ck_zl<br /> from tbKuCunJiLuBiao as kc left join tbChuKuWuZiJiLu as ck on kc.char_KCJLB_SN=ck.char_CKWZJL_ShangJiWZSN group by kc.char_KCJLB_SN<br /> ) as ck_wz,<br /> --销售<br /> (<br /> --销售、出库量<br /> --直接得到的量：销售数量(xs_sl)、销售重量(xs_zl)、销售出库数量(xsck_sl)、销售出库重量(xsck_zl)<br /> --间接得到的量：已销售未出库数量(xs_ck_sl)、已销售未出库重量(xs_ck_zl)<br /> select tbxs.char_XSWZJL_XiangGuanWuZiSN ,sum(tbxs.float_XSWZJL_ShuLiang) as xs_sl,sum(tbxs.float_XSWZJL_ZhongLiang) as xs_zl,sum(tbxsck.ck_sl) as xsck_sl,sum(tbxsck.ck_zl) as xsck_zl<br /> from tbXiaoShouWuZiJiLu as tbxs,<br /> --销售出库<br /> (select xs.char_XSWZJL_SN,sum(ck.float_CKWZJL_YingTiShuLiang) as ck_sl,sum(ck.float_CKWZJL_YingTiZhongLiang) as ck_zl<br /> from tbXiaoShouWuZiJiLu as xs left join tbChuKuWuZiJiLu as ck on xs.char_XSWZJL_SN=ck.char_CKWZJL_WuZiSN group by xs.char_XSWZJL_SN)<br /> as tbxsck<br /> where tbxs.char_XSWZJL_SN=tbxsck.char_XSWZJL_SN<br /> group by tbxs.char_XSWZJL_XiangGuanWuZiSN</p> <p> ) as xs_wz<br /> where ck_wz.char_KCJLB_SN=xs_wz.char_XSWZJL_XiangGuanWuZiSN<br /> ) as tbck_tbxs<br /> where tbkcjl.char_KCJLB_SN=tbck_tbxs.char_KCJLB_SN