Recently I had a problem where in an HQL query the result contained duplicates. I used implicit joins in the my query and it looked like the following: from Order o where (o.Code like :literal OR o.CustomData like :literal OR o.Customer.Code like :literal...