xxx

超市的销售

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