I have the problem and I can not resolve it. How to turn this query into NHibernate Criteria.
SELECT ordid, prodid, qty
FROM item
WHERE (prodid, qty) IN
(SELECT prodid, qty
FROM item
WHERE ordid = 365)
Thank you for helping.