SELECT SUM(ylmx_flag * ylmx_shuliang) AS SUM, ylmx_huono, ylmx_mbianhao,
yl_cangkuname, ylmx_clname, yl_time
FROM Kylmingxi, kyongliao
WHERE Kylmingxi.ylmx_ylbianhao = kyongliao.yl_bianhao
GROUP BY ylmx_huono, ylmx_mbianhao, ylmx_clname, yl_cangkuname, yl_time
HAVING yl_time >= '2005-12-22'
注:Ms server 为time>'2005-12-22'而Access中为time>#2005-12-22#