Hi guys,

I been searching the forum, found few things but nothing that will solve this problem. So i turn to you for help.

Here is how the query would look in sql

table -> people
ppl_id
lname
fname

table -> positions
pos_id
position_name
position_type
ppl_id (forign_key)


select * from people, (select position_name, ppl_id from positions where position_type = 'Manager') pos
where people.ppl_id = pos.ppl_id (+)

so what i am trying to do is put this query with a subquery and an outer coin in to a criteria class (I can do it with sql and hql) .

Is this possible.

I found post how to do a subquery with Detachedquery, but most of them put the query in the where area, i need it the form area.

thank you.

Robert,

bumpski
sorry!!

I found some information in the forum that hibernate does not support
“from clause subqueries” in criteria and in HQL (the post was referring to hib v2)


does any one know if this is true for hib 3?

Any body know why this is not supported?

I might start developing something that can be use for that!!

I guess my alternatives are to map some views that use subqueries in the from clause.[/b]