SELECT SUM(ljt_GZL_view.sl) AS sl, MAX(ljt_GZL_view.dj) AS dj, SUM(ljt_GZL_view.dj * ljt_GZL_view.sl) AS Expr1, MAX(ljt_GZL_view.bh) AS Expr2 FROM ljt_GZL_view,CB_zhaodai WHERE 这里还要有两个表的key相连 不然出来的是笛卡儿积 ljt_GZL_view.xh <> CB_zhaodai.xh and ljt_GZL_view.bh = 10023) AND (ljt_GZL_view.fwy = '2 ' AND (ljt_GZL_view.sj BETWEEN '2002-09-13 00:00:00' AND '2002-09-14 00:00:00') GROUP BY ljt_GZL_view.bh ================================================================ok?
SUM(ljt_GZL_view.sl) AS sl, MAX(ljt_GZL_view.dj) AS dj,
SUM(ljt_GZL_view.dj * ljt_GZL_view.sl) AS Expr1, MAX(ljt_GZL_view.bh) AS Expr2
FROM ljt_GZL_view,CB_zhaodai
WHERE
这里还要有两个表的key相连 不然出来的是笛卡儿积
ljt_GZL_view.xh <> CB_zhaodai.xh and
ljt_GZL_view.bh = 10023) AND (ljt_GZL_view.fwy = '2 '
AND (ljt_GZL_view.sj BETWEEN '2002-09-13 00:00:00'
AND '2002-09-14 00:00:00')
GROUP BY ljt_GZL_view.bh
================================================================ok?