hibernate中的hql语句报错。

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]

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

错误信息太少了，应该把整个错误信息都贴出来看看

更改Score 的别名 不要用类名 像这种多表查询 我都是join的

from Score sco left join fetch Student stu order by stu.class ASC; (class应该是另外一个表中的按需修改一下)

不能用select吧