First, try to do it in pure SQL.
Second, If u want to return ObjectB List U can map rout SQL query to Object
your query, Object.class);
after that u can try to change it to H/EJB/JPQL query.
The problem is that i'm still in the first step:
try to do it in pure SQL. :)
I can concat a lot of
ors but i dont think that it's a good practice. So that's why im asking.
Thks in advance.