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]