I am now using hibernate as ORM in my application

I am not that familiar with join query. So my question is as dipicted below:

Scenario:

I have got three tables.

Order Table
（PK）
ID ORDER_CODE STATUS

1 jialhe001 ORDERED
2 jialhe002 ORDERED


OrderProduct Table

（PK） (Order_PK) (Product_PK)
ID ORDER_ID QTY PROD_CODE

1 1 10 XXD
2 1 12 YYD

Product Table

（PK）
PROD_CODE description price

XXD toys 12
YYD cars 10


I need product.description, product.price, order.status, orderproduct.qty

How to write JOIN query?

P.S.:I have realized it by using other approach. But I am not satisfatied with that.
I am just wondering how to write query based on JOIN.


Thanks in advance.

Hello
I am stuck with a similar issue.Please suggest a solution if you have got it working.
:(
Posted my topic here
https://forum.hibernate.org/viewtopic.php?f=1&t=1014372

Thanks
Sachin

Hi,
May you join your mapping (xml or annotated class)? It will be of great help to provide an answer.
Join query can be implicit by using manytoone, onetoone mapping.