Hi, I would like to fire the following SQL query through NH.
SELECT <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <K.> FROM T1 q, T2 k WHERE (<field> like 'abc' or <field> like 'xyz') GROUP BY <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <> HAVING count(<k.>) >= 2 UNION SELECT <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <K.> FROM T1 q, T2 k WHERE ((<field> like 'abc%' and <field> <> 'xyz') or (<field> like 'abc %' and <field> <> '<value>')) GROUP BY <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <W> HAVING count(<k.>) >= 2 UNION SELECT <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <K.> FROM T1 q, T2 k WHERE (<> like 'abc') GROUP BY <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <field> HAVING Count(<k.>) = 1 UNION SELECT <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <K.> FROM T1 q, T2 k WHERE (<> like 'abc') AND <k.> = <q.> AND <K.> = 'J' AND NVL ( <K.>, 'N' ) != 'J' GROUP BY <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <K.>, <W> HAVING Count(<k.>) = 1 ORDER BY <H> DESC; Is it possible to construct the above query in NH. One solution is to create a view of the above query and then fire the SQL on the view. Thanks & regards, Anil -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
