create select

hlavki · **Joined:** Mon Feb 28, 2005 6:11 pm **Posts:** 6

Hello,

I newbie to Hibernate and I don't know how to write select in hql... ;) In sql there is no problem...

Model is here:

hbm.xml files are clear... ;) I hope...

I need to write query in hql...
select all Problems with ProblemContents where Test = ID_Test
ordered by test.i_order_id, problemContent.i_order_id

in SQL:

Code:

SELECT p.* FROM Problem p
  JOIN l_problem_to_test pt USING (i_problem_id)
  JOIN c_problem_content pc USING (i_problem_id)
ORDER BY pt.i_order_id, pc.i_order_id;

thanx, miso

mveitas · **Posted:** Tue Mar 08, 2005 10:02 am

http://hibernate.org/5.html