joining tables

Lucrus · **Joined:** Fri Feb 15, 2008 11:21 am **Posts:** 3

Hello *,

I have two tables that are one2one by means of id columns. I need to join them, filter by a field value in tab2, order by a field value in tab1, but then I need only tab1 results. If I use:

Code:

"from tab1 a, tab2 b where b.parent = 0 order by a.name"

I get a List<Object[]> as a result. However I need only tab1 rows, tab2 is included only because of the "where" clause. I'd like to have a List<Tab1> result instead. Is that possible or am I forced to run two different queries?