Hql连接查询的两个错误（Path expected for join!和unexpected token on）

1. Path expected for join!

Path expected for join! [SELECT count() FROM cn.com.jsoft.entities.TDSysnphoto p left join TDSysnotice s where p.snid = s.id]; nested exception is org.hibernate.hql.ast.QuerySyntaxException: Path expected for join! [SELECT count() FROM cn.com.jsoft.entities.TDSysnphoto p left join TDSysnotice s where p.snid = s.id]

解决方案：这个错误的原因是Hibernate不认识join，我们需要将Left join改成，即可，‘，’也是连接查询

unexpected token on

org.hibernate.hql.ast.QuerySyntaxException: unexpected token: on near line 1, column 153 [select cust.name,cust.sex,cust.birthday,cust.idType,cust.idNo,cust.phone,clu.physicalNo From

解决方案：在Hibernate中不允许存在on，将on改为Where就可以了。