时间比较

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#

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

私密
私密原因:
请选择设置私密原因
  • 广告
  • 抄袭
  • 版权
  • 政治
  • 色情
  • 无意义
  • 其他
其他原因:
120
出错啦
系统繁忙,请稍后再试

关闭