select a.strno,a.strnam,b.sum(score) from
(select strno,strnam from name where strnam >2) a,
(select strno,sum(score) from score where strdate>'1-1月-2009' group by strno having sum(score)>300) b
where a.strno=b.strno group by a.strno,a.strnam表A中是学号和学名,表B中是学号和成绩,我想输出一张今年学名大于2个字的,成绩大于300分的表格。
但是执行后总是报错,b.sum(score) 是无效标识符,请各位指点一下吧
(select strno,strnam from name where strnam >2) a,
(select strno,sum(score) from score where strdate>'1-1月-2009' group by strno having sum(score)>300) b
where a.strno=b.strno group by a.strno,a.strnam表A中是学号和学名,表B中是学号和成绩,我想输出一张今年学名大于2个字的,成绩大于300分的表格。
但是执行后总是报错,b.sum(score) 是无效标识符,请各位指点一下吧
解决方案 »
- 关于dataCombo
- 请问如何将外部图像放到vb界面中
- vb的ftp
- 统计问题?
- 急!急!急!急!急!急!急!急!急!急!急!急!急!急!急!
- 在VB中用过Flash控件 VB如何得到FLASH中的变量值!
- 祝贺老吴当斑竹~~~~~~~~~~散分庆祝哦~
- 怎么向文件中写入特别按键?
- Set newitem = ListView.ListItems.Add(, rs("ytid"), rs("dwmc"))提示 typemismatch 为什么?rs("ytid")=y123 rs("dwmc")=4yyyy")
- 一个男生的困惑!!!!
- vb网络编程
- 请问将word模板中的表格数据导入到MSFlexGrid里有没有办法提供速度?
(select strno,strnam from name where strnam >2) a,
(select strno,sum(score) from score where strdate>'1-1月-2009' group by strno having sum(score)>300) b
where a.strno=b.strno group by a.strno,a.strnam
, a.strnam
, sum(b.score)
from (select strno
, strnam
from name
where strnam >2
) a
, (select strno
, sum(score) as score
from score
where strdate>'1-1月-2009'
group by strno
having sum(score)>300
) b
where a.strno=b.strno
group by a.strno,a.strnam
, a.strnam
, sum(b.score)
from (select strno
, strnam
from name
where strnam >2
) a
, (select strno
, sum(score) as score
from score
where strdate>'1-1月-2009'
group by strno
having sum(score)>300
) b
where a.strno=b.strno
group by a.strno,a.strnam
ORA-00904:"B"."SCORE":无效的标识符
, a.strnam
, sum(b.score)
from (select strno
, strnam
from name
where strnam >2
) a
, (select strno
, sum(score) as score
from score
where strdate>'3-5月-2009'
group by strno
having sum(score)>100
) b
where a.strno=b.strno
group by a.strno,a.strnam
, a.strnam
, b.score)
from (select strno
, strnam
from name
where strnam >2
) a
, (select strno
, sum(score) as score
from score
where strdate>'1-1月-2009'
group by strno
having sum(score)>100
) b
where a.strno=b.strno