posted 12 years ago
Good day,
I have a DB query as following which give me correct result, and when i try on my HQL and it provide me incorrect result.
Database:
SQL query :
Result : 2 rows return correctly
My HQL:
Result: Return 2 set of 4 rows records, both set's records are same. (Question: 1- Why it show me 2 set of same record? 2- What need to change in my HQL?)
Below is my entity class: