- This topic has 3 replies, 2 voices, and was last updated 14 years, 3 months ago by
.
-
Posts
-
How do you do something like this in HQL with no relationship between each table? I don’t want to use RAW Query. I want to achieve this by using HQL or Criteria.
Query below work in Oracle
select t.*
from Outsource_Invoice_Data t,
Rms_Mexico_Invoice_Filters t2,
Rms_Mexico_Invoice_Filters t3
where t.bt_Code = t2.filter_Code(+)
and t2.filter_Code is null
and to_char(t.gp_Num) = t3.filter_Code(+)
and t3.filter_code is null
order by t.customer_Idkvphan,
Please refer http://stackoverflow.com/questions/974085/join-without-association-in-hql and http://stackoverflow.com/questions/720502/hibernate-criteria-joining-table-without-a-mapped-association
I would recommend you crosspost on Hibernate forums.support-joy,
your link result in an inner join. I need a left outer join and I don’t think hibernate is capable of doing that if the two table have no relationship.kvphan,
In your initial query, you haven’t mentioned anything regarding left outer join. I am not sure on how to perform left outer join on 2 tables having no relationship. Can you cross-post on hibernate forums – https://forum.hibernate.org/
