xxx

1. 纯粹的合同管理,不涉及其它业务,独立成系统2. 简单明了,流程清析3. 合同条款可预定制4. 丰富强大的打印预览系统5. 实用的导入导出功能,可与excel交互使用6. 时刻追踪合同执行情况,包

SELECT tab_fdjhd.spbm,tab_fdjhd.fdmc,tab_fdjhd.spnum as spnum,
(select t_spxx.spmc from t_spxx where t_spxx.spbm=tab_fdjhd.spbm) as spmc, 
      ISNULL
          ((SELECT SUM(t_stocksp.spnum)
          FROM t_stocksp
          WHERE t_stocksp.spbm = tab_fdjhd.spbm AND t_stocksp.ckmc =:ckmc ), 0) 
      AS stocknum
FROM tab_fdjhd