This week's book giveaway is in the Mac OS forum. We're giving away four copies of a choice of "Take Control of Upgrading to Yosemite" or "Take Control of Automating Your Mac" and have Joe Kissell on-line! See this thread for details.
Well not in is a valid HQL expression. ItDoesntWorkIsUseless, you have posted the SQL which is a good way to show us what you are trying to achieve. What we are missing is the HQL you are trying and a better description (like a stack trace) with the error you are getting. If you post the HQL that you are trying we may be able to give you pointers as to why it is not working.
subject: HQL to get all the records in one table but in not other