Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

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?