does anyone knows the equivalent hibernate criteria for this native sql?
Code:
select this_.QUERY_DT as QUERY1_2_1_,
this_.LINK as LINK2_1_,
this_.YYYYMM as YYYYMM2_1_,
this_.YYYYWW as YYYYWW2_1_,
cal1_.QUERY_DT as QUERY17_2_3_,
cal1_.QUERY_DT as QUERY17_0_0_,
cal1_.SITE as SITE0_0_,
cal1_.TYPE as TYPE0_0_,
cal1_.WORK_PCT as WORK16_0_0_
from TABLE_A this_
left outer join (select * from TABLE_B ex where ex.site='PO' and ex.type='SITE') cal1_ on this_.query_dt = cal1_.query_dt
where this_.YYYYMM = 201107
thanks,
alva