小弟相死，想上代码
从表
<many-to-one name="tblDrpBusiness" class="com.teamsun.drp.po.TblDrpBusiness" fetch="join" lazy="false">
<column name="Business_id" length="4" />
<column name="version" length="10" />
</many-to-one>
主表
<set name="tblDrpBuExeIndexes" inverse="true" lazy="true">
<key>
<column name="Business_id" length="4" />
<column name="version" length="10" />
</key>
<one-to-many class="com.teamsun.drp.po.TblDrpBuExeIndex" />
</set>
hql查询语句
"select t.tblDrpBuExeIndexes from TblDrpBusiness t inner join t.tblDrpBuExeIndexes e where t.id.businessId='"+businessID+"' and t.id.version='"+version+"' and e.exeFlag <> 'DONE' and e.exeFlag <> 'CANCEL'"
解释下啊。由于hibernate版本问题，就加上inner join 了，不然会报错。但是加后不报错了，数据结果又不对了
select tbldrpbuex2_.Bu_exe_seq as Bu1_21_, tbldrpbuex2_.Bu_exe_name as Bu2_21_,
tbldrpbuex2_.Exe_start_t as Exe3_21_, tbldrpbuex2_.Exe_end_t as
Exe4_21_, tbldrpbuex2_.Cur_step as Cur5_21_, tbldrpbuex2_.Exe_flag
as Exe6_21_, tbldrpbuex2_.Fail_flag as Fail7_21_, tbldrpbuex2_.operator
as operator21_, tbldrpbuex2_.Lauch_site as Lauch9_21_,
tbldrpbuex2_.Control_site as Control10_21_, tbldrpbuex2_.Step_seq
as Step11_21_, tbldrpbuex2_.Context_para_value as Context12_21_,
tbldrpbuex2_.Ip_addr as Ip13_21_, tbldrpbuex2_.Cmd_count as
Cmd14_21_, tbldrpbuex2_.Reply_count as Reply15_21_, tbldrpbuex2_.Info_count
as Info16_21_, tbldrpbuex2_.Operation_result as Operation17_21_ from
drp.tbl_drp_business tbldrpbusi0_ inner join drp.tbl_drp_bu_exe_index tbldrpbuex1_ on
tbldrpbusi0_.Business_id=tbldrpbuex1_.Business_id and tbldrpbusi0_.version=tbldrpbuex1_.version
inner join drp.tbl_drp_bu_exe_index tbldrpbuex2_ on
tbldrpbusi0_.Business_id=tbldrpbuex2_.Business_id and tbldrpbusi0_.version=tbldrpbuex2_.version where
tbldrpbusi0_.Business_id='1021' and tbldrpbusi0_.version='V1.0' and tbldrpbuex1_.Exe_flag<>'DONE'
and tbldrpbuex1_.Exe_flag<>'CANCEL'
生成出的SQL有两个inner join，结果当然不对咯，你看相死不
然后手动改SQL，删除其中inner join
select tbldrpbuex2_.Bu_exe_seq as
Bu1_21_, tbldrpbuex2_.Business_id as
Business2_21_, tbldrpbuex2_.version as
version21_, tbldrpbuex2_.Bu_exe_name as
Bu4_21_, tbldrpbuex2_.Exe_start_t as
Exe5_21_, tbldrpbuex2_.Exe_end_t as
Exe6_21_, tbldrpbuex2_.Cur_step as
Cur7_21_, tbldrpbuex2_.Exe_flag as
Exe8_21_, tbldrpbuex2_.Fail_flag as
Fail9_21_, tbldrpbuex2_.operator as
operator21_, tbldrpbuex2_.Lauch_site as
Lauch11_21_, tbldrpbuex2_.Control_site as
Control12_21_, tbldrpbuex2_.Step_seq as
Step13_21_, tbldrpbuex2_.Context_para_value as
Context14_21_, tbldrpbuex2_.Ip_addr as Ip15_21_,
tbldrpbuex2_.Cmd_count as Cmd16_21_, tbldrpbuex2_.Reply_count
as Reply17_21_, tbldrpbuex2_.Info_count as Info18_21_,
tbldrpbuex2_.Operation_result as Operation19_21_ from
drp.tbl_drp_business tbldrpbusi0_ inner join
drp.tbl_drp_bu_exe_index tbldrpbuex2_ on tbldrpbusi0_.Business_id=tbldrpbuex2_.Business_id
and tbldrpbusi0_.version=tbldrpbuex2_.version
where tbldrpbusi0_.Business_id='1021' and tbldrpbusi0_.version='V1.0'
and tbldrpbuex2_.Exe_flag<>'DONE' and tbldrpbuex2_.Exe_flag<>'CANCEL'
结果相当完美。就是我想要的
狗日的，网上查了，不知道如何查啊。似乎没人遇到过这狗屁问题。高人赐教。。hibernate真头痛。希望高人提供有价值。。解决办法
