28,404
社区成员
发帖
与我相关
我的任务
分享请问这条sql语句错在哪？
sql="insert into SpecialList(Special,Singer,SongCount) (select Special,Singer,Count(Singer) as SongCount from SongList group by Singer,Special) as b where SpecialList.Special<>b.Special and SpecialList.Singer<>b.Singer"
...全文
请发表友善的回复…
发表回复
zyug 2005-09-22
- 打赏
- 举报
上面我看错了
你的查询子句有问题
你应该再嵌套一下
你的查询子句有问题
你应该再嵌套一下
zyug 2005-09-22
- 打赏
- 举报
你的这个语句有问题呀
应该是这样呀
insert into SpecialList(Special,Singer,SongCount)
select * from
(select Special,Singer,Count(Singer) as SongCount from SongList group by Singer,Special) as b where SpecialList.Special<>b.Special and SpecialList.Singer<>b.Singer
应该是这样呀
insert into SpecialList(Special,Singer,SongCount)
select * from
(select Special,Singer,Count(Singer) as SongCount from SongList group by Singer,Special) as b where SpecialList.Special<>b.Special and SpecialList.Singer<>b.Singer
OnlyVB 2005-09-22
- 打赏
- 举报
晕，看语句还不知道？
把一个数据库里的数据往另一个数据库里导
把一个数据库里的数据往另一个数据库里导
itzhiren 2005-09-22
- 打赏
- 举报
要实现什么功能？
