title: How to convert mysql join query using criteria in hibernate
body: <p>I want to convert the below MySql query to hibernate using criteria.
  tbl_state and tbl_country are the tables that I want to join where tbl_state and tbl_country has a common field country_id.</p>
  
  <pre><code>    select s.*,c.country_name from tbl_state s,tbl_country c where 
      s.country_id=c.country_id ORDER BY s.state_name 
      + order + " LIMIT " + pagesize + " OFFSET " + pagesize * pagenum;
  </code></pre>