Criteria: Subquery with multiple columns

2

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.

    
asked by anonymous 28.05.2015 / 22:08

0 answers