posted 15 years ago
Hibernate version: Hibernate 3
This is my SQL query:
SELECT notification.div_id, notification.pa_no paNumber , criteria.pa_criteria_desc paOutboundCriteriaDesc
FROM pa_outbound_notification notification
Left JOIN pa_outbound_criteria criteria
ON notification.pa_criteria_desc LIKE criteria.pa_criteria_desc
where notification.div_id = '101'
What would be the logical replacement of HQL?