 <p>Could it be something simple like this:</p> <pre><code> query = em.createNativeQuery("SELECT state_id, state_name, country_id FROM state_table,country WHERE state_table.country_id=country.country_id and country.country_name = ?1)").setParameter(1, country_name); list = (List&lt;Object&gt;) query.getResultList(); </code></pre> <p>where country_name is the parameter you are searching for and list is the list of objects returned by the native query?</p>