insert into kucun (name,num,atime)
select name, Sum(num) as num, atime from
((select name, Sum(num) as num,CONVERT (varchar(7), atime ,20) as atime from ruku where atime like '2004-01%' group by Name ,CONVERT (varchar(7), atime ,20))
union all
(select name, Sum(-num) as num,CONVERT (varchar(7), atime ,20) as atime from chuku where atime like '2004-01%' group by Name ,CONVERT (varchar(7), atime ,20)))
A group by name, atime上面的Sql 语句我在Sql数据库执行成功,但换到Access数据库中执行就无法通过,错误为“Jion语句错误”,请大家帮忙解决一下??
select name, Sum(num) as num, atime from
((select name, Sum(num) as num,CONVERT (varchar(7), atime ,20) as atime from ruku where atime like '2004-01%' group by Name ,CONVERT (varchar(7), atime ,20))
union all
(select name, Sum(-num) as num,CONVERT (varchar(7), atime ,20) as atime from chuku where atime like '2004-01%' group by Name ,CONVERT (varchar(7), atime ,20)))
A group by name, atime上面的Sql 语句我在Sql数据库执行成功,但换到Access数据库中执行就无法通过,错误为“Jion语句错误”,请大家帮忙解决一下??
解决方案 »
- 自写delphi基类(属性是packed record),继承基类之后。属性没法用,出现‘Left side cannot be assigned to’
- 第一次提问:怎样取矢量图XY坐标?
- 如何用程序向剪贴版添加一段文字?谢谢
- 中文字符打印如何分行?
- 如何做跨库查询?
- 关于com+远程对象的创建和调用,创建时出现错误(没有注册类别)
- 谁发给我李维23日在成都讲课的PowerPoint文件和示例文件,十分感谢。EMail: [email protected]
- 高分求购 delphi网络传输文件程序
- 38岁了,还可以学习JAVA
- 初学者求助!!!
- 再次提问,有关创建一个窗口的问题!解决此问题另开贴500分!
- 200分求完整的c/s(客户/服务器)的实例,分若不够,还可加。
ACCESS日期比较用##把日期廓起来进行日期的比较