title: Join multiple tables in HQL
body: <p>Can anyone help me to convert this query in to HQL</p>
  
  <pre><code>SELECT      
    supplierOrderDetails.productID,
    supplierOrderDetails.orderQty,
    supplierOrderReceiveDetail.qtyArrived
  FROM
   supplierOrder
  INNER JOIN
    supplierOrderDetails
  ON
    (supplierOrderDetails.supplierOrderID = supplierOrder.ID)
  INNER JOIN 
      supplierOrderReceive
  ON  
   (supplierOrderReceive.supplierOrderID = supplierOrder.ID)
  INNER JOIN 
      supplierOrderReceiveDetail
  ON  
   (supplierOrderReceiveDetail.supplierOrderReceiveID = supplierOrderReceive.ID)  
     AND 
   (supplierOrderReceiveDetail.ProductID =supplierOrderDetails.ProductID)     
  WHERE supplierOrder.ID = 1
  </code></pre>
  
  <p>Here is the table relationship</p>
  
  <p><img src="https://i.stack.imgur.com/3OoXi.png" alt="enter image description here"></p>