hibernate中我查询两张表中的数据,我这样写查询语句,但就是抱错 select t.name,t.type,s.name from Ren t inner join Type s on t.type=s.id 错误如下: org.hibernate.hql.ast.QuerySyntaxException: unexpected token: on near line 1, column 64 [select t.name,t.type,s.name from liubi.Ren t inner join Type s on t.type=s.id]
inner join fetch t on s.trackerid = t.id这个是我的错误 ~ 这个是不是需要在映射对象的配置文件配置一个关联那?
<set name="terminals" table="TERMINALS" >
<key column="TRACKERID"/>
<many-to-many column="ID" class="com.gprs.ssh.obj.terminals"
unique="true"/>
</set>我加了这个配置还是没好使~!~
<key>
<column name="ddc_proj_no"/>
</key>
<element type="java.lang.String" column="res_id"/>
</set>
<set name="resource_info_ws" inverse="true" table="assign_info_w" lazy="false" order-by="res_id">
<key>
<column name="ddc_proj_no"/>
</key>
<many-to-many class="com.rmt.entity.Resource_info_w" column="res_id"/>
</set>
你最好换成SQL语句查询