SELECT SUM(ylmx_flag * ylmx_shuliang) AS SUM, ylmx_huono, ylmx_mbianhao, yl_cangkuname, ylmx_clname, yl_timeFROM Kylmingxi, kyongliaoWHERE Kylmingxi.ylmx_ylbianhao = kyongliao.yl_bianhaoGROUP BY ylmx_huono, ylmx_mbianhao, ylmx_clname, yl_cangkuname, yl_timeHAVING yl_time >= '2005-12-22'
注：Ms server 为time>'2005-12-22'而Access中为time>#2005-12-22#
