Criteria: Subquery with multiple columns

Asked

Viewed 425 times

2

I have the problem and I can’t solve 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)

Grateful to help.

  • C#? VB.NET? Any other platform language? What have you tried?

  • It could be in any language. But the application is in c#. Thanks for the comment @Brunocésar

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.