hibernate中的hql语句报错。

Question

sql语句是
select score.sno,cno,class,ascore,bscore,sumscore
from score,student
where student.sno=score.sno
order by class ASC
能够执行，换成Hql语句应该怎么换？？已经将表的名字改成大写了。

错误是：
org.hibernate.hql.ast.QuerySyntaxException: unexpected token: , near line 1, column 21 [select Score.sno,cno,class,ascore,bscore,sumscore from Dao.Score,Dao.Student where (Student.sno=Score.sno) order by class ASC]

Answer 1

from Dao.Score Score ,Dao.Student Student ，试下改这个，还有select指定是哪个表的字段