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 -~----------~----~----~----~------~----~------~--~---
