title: Inner Joins Query in HQL
body: <p>I'm unable to execute HQL for Inner Joins, Query is executing correct at sql but not in HQL.
  I don't know where i'm missing. Your help is appreciable.</p>
  
  <pre><code> ***Error***: org.hibernate.hql.ast.QuerySyntaxError: unexpected token: ON near line 1, column 148 [SELECT op.username, op.email, orders.p_id, orders.o_id, product.listed_price FROM com.model.Orders  orders INNER JOIN orders.OrderProcessing as op ON op.u_id = orders.u_id INNER JOIN orders.Product as product ON product.p_id = orders.p_id WHERE product.p_id = '208' ORDER BY op.username]
  
  productList = (List&lt;Orders&gt;) session.createQuery(
   "SELECT op.username, op.email, orders.p_id, orders.o_id, product.listed_price " +                                                                               
   "FROM Orders orders " +                                                                   
   "INNER JOIN orders.OrderProcessing as op " +                                                                                       
   "ON op.u_id = orders.u_id " +                                                         
   "INNER JOIN orders.Product as product " +                                                              
   "ON product.p_id = orders.p_id " +                                                        
   "WHERE product.p_id = '"+p_id +"' " +                                                         
   "ORDER BY op.username"
  ).list();
  </code></pre>