hi, i have this sql string here:

SELECT p.produktnavn, k.knavn FROM produkt p JOIN (produktkategori pk, kategori k) ON (p.id=pk.produktid AND pk.kategoriid=k.id) JOIN (produktfarge pf, farge f) ON (p.id=pf.produktid AND pf.fargeid=f.id) where k.id = '1164113247767' and p.pris between 0 and 5000 and f.id = '1164113248104';


how can i do that in hibernate? i have three classes that are connected with that called FargeData, ProduktData and KategoriData...any idea? you may find a pic of the ER model here: http://jicoma.com/forum/screenshot.png

thanks in advance :-)

no ideas ? :-|

Let us know what type of query you would like to use:

- HQL
- EJB-QL?
- Criteria Query?
- Native SQL?