I'm sure there are many posts in this forum to map a Database View to an entity.
in your case you need to create a database view
create view subresult as
select f1,f2,f3 from pojo1 p1,pojo2 p2
where p1.f4=p2.f8
create a POJO which will have the setters and getter's matching the column names and
create hibernate .hbm file describing the mapping from database view to POJO.
Then in HQL:-
Select P.name,subresult.f2,subresult.f2
subresult, pojo3 P
where subresult.f3=P.f1
see this as reference:-
http://forum.hibernate.org/viewtopic.ph ... highlight=
hope this helps,
Latha.