标题: [已解决]一段sql查询语句报错 [打印本页] 作者: coolabc 时间: 2008-6-5 10:27 标题: [已解决]一段sql查询语句报错 SELECT Max(d.dDate) AS 最近销售日期, ds.cInvCode AS 存货编码, Sum(ds.iQuantity) AS 发货数量 INTO 今年发货情况表
FROM dbo_dispatchlist AS d, dbo_dispatchlists AS ds
WHERE (((d.dDate)>'#2008-01-01#'))
GROUP BY ds.cInvCode;
提示说标准表达式中数据类型不匹配！
[ 本帖最后由 coolabc 于 2008-6-5 12:08 编辑 ]作者: tz-chf 时间: 2008-6-5 10:50
日期不要加单引号作者: coolabc 时间: 2008-6-5 11:02
SELECT Max(d.dDate) AS 最近销售日期, ds.cInvCode AS 存货编码, Sum(ds.iQuantity) AS 发货数量 INTO 今年发货情况表
FROM dbo_dispatchlist AS d, dbo_dispatchlists AS ds
WHERE (((d.dDate)>#2008-01-01#))
GROUP BY ds.cInvCode;
成功了，感谢！