Perhaps I misunderstood your SQL but that is equivalent to SELECT * FROM TRANSACTION T WHERE T.TRANSACTION_ID NOT IN (SELECT TRANSACTION_ID FROM POST_ENTRY)
The HQL now is from Transaction T where T not in (select Transaction from PostEntry) -Markus BTW: The HQL section of the reference documentation is awesome, so please also RTM. 2009/8/27 Shane C <[email protected]> > > I'm trying to find out how I'd convert the following into HQL... > > SELECT T.* FROM POST_ENTRY E RIGHT OUTER JOIN TRANSACTION T > ON E.TRANSACTION_ID = T.TRANSACTION_ID > WHERE E.TRANSACTION_ID IS NULL; > > I can get as far as... > > SELECT T FROM PostEntry RIGHT OUTER JOIN Transaction T > WHERE ... and then I get lost... > > I'd assume this can be done but I'm not sure of the syntax.. any > suggestions? > > Thanks, > > Shane > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
