可以试试这个办法 将SELECT foxin_rkdetail.wl_code, foxin_rkdetail.wl_name, wlda.wllb,
- foxin_rkdetail.wl_sl AS cksl, foxin_rkdetail.wl_totalAS zj, foxin_rk.ld_date
FROM foxin_rkdetail INNER JOIN
wlda ON foxin_rkdetail.wl_code = wlda.wlbh INNER JOIN
foxin_rk ON foxin_rkdetail.dj_code = foxin_rk.dj_code
WHERE (foxin_rkdetail.dj_code LIKE 'BS%') AND (foxin_rk.ld_date>= '2004-7-1') AND (foxin_rk.ld_date< '2004-7-15')
创建为视图。另外再写语句在视图上按日期进行汇总,这个日期段估计是由用户来选择的在前台要做处理.
- foxin_rkdetail.wl_sl AS cksl, foxin_rkdetail.wl_totalAS zj, foxin_rk.ld_date
FROM foxin_rkdetail INNER JOIN
wlda ON foxin_rkdetail.wl_code = wlda.wlbh INNER JOIN
foxin_rk ON foxin_rkdetail.dj_code = foxin_rk.dj_code
WHERE (foxin_rkdetail.dj_code LIKE 'BS%') AND (foxin_rk.ld_date>= '2004-7-1') AND (foxin_rk.ld_date< '2004-7-15')
创建为视图。另外再写语句在视图上按日期进行汇总,这个日期段估计是由用户来选择的在前台要做处理.
SELECT foxin_rkdetail.wl_code,foxin_rkdetail.wl_name, wlda.wllb,
-SUM(foxin_rkdetail.wl_sl) AS cksl,
SUM(foxin_rkdetail.wl_total) AS zj,
-- foxin_rk.ld_date
FROM foxin_rkdetail INNER JOIN
wlda ON foxin_rkdetail.wl_code = wlda.wlbh INNER JOIN
foxin_rk ON foxin_rkdetail.dj_code = foxin_rk.dj_code
WHERE (foxin_rkdetail.dj_code LIKE 'BS%')
AND (foxin_rk.ld_date>= '2004-7-1')
AND (foxin_rk.ld_date< '2004-7-15')
GROUP BY foxin_rkdetail.wl_code, foxin_rkdetail.wl_name, wlda.wllb,
-- foxin_rk.ld_date