This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
<code>SELECT ch.* FROM channel ch LEFT JOIN channel_type_rel ctr ON (ctr.channel_id = ch.channel_id) LEFT JOIN channel_type ct ON (ctr.channel_type_id = ct.channel_type_id) WHERE ct.channel_type_id IN (:channelTypes) </code>
Apparently, this does not works, so I'd like to ask if there's some way how to achieve this (does not matter how), preferably with pure JPQL, as code is deployed to two environments, one with Hibernate and the other with TopLink. If it's not possible with pure JPQL, HQL is preferred then.