This week's book giveaway is in the OCP forum. We're giving away four copies of OCP Oracle Certified Professional Java SE 11 Developer Practice Tests and have Scott Selikoff and Jeanne Boyarsky on-line! See this thread for details.
Thanks James for your guidance, I have try and the result appear the same ...I think it could be ITEM_gid duplication.
Currently, I'm pull all the record and use the if statement to filter out unnecessary return record..sound bad but working at the moment...I'll definitely try to make a simple sample after my tasks meet the timeline..
I'm just curious, our entity already define the relationship, do we still need to join again in the HQL? would it take as extra join?