时间比较

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#

阅读更多
想对作者说点什么?

博主推荐

换一批

没有更多推荐了,返回首页