HQL query one-to-many relationship stored in a map
<p>I have a database with managers and employees, where one manager can have many employees or none, and each employee can only have one manager. Is there a way to query the database to return a map such as Map &lt; manager, List&lt; employee > > ? </p>

<p>I know I could create a loop querying one manager at a time and return a list of their employees saving that in the map but, with a large database this would be extremely inefficient. </p>

<p>I know if I pass one manager at a time I could write a outer right query such as </p>

<pre><code>SELECT m.managerName, e.employeeName FROM Manager m NATURAL RIGHT OUTER JOIN employee e WHERE m.managerName = '';
</code></pre>

<p>but putting this in a loop would take to long.
Thank you for any help. </p>