HQL

select p from People p left join  fetch p.events where p.people_id=:pid

 

 

<hibernate-mapping package="org.hibernate.tutorial.domain">
    <class name="People" table="t_people" lazy="false">
        <id name="id" column="people_id">
            <generator class="increment" />
        </id>
        <property name="age" type="int"></property>
        <property name="firstname"></property>
        <property name="lastname"></property>
        <set name="events" table="people_event" lazy="false">
            <key column="people_id"></key>
            <many-to-many column="event_id" class="Event"></many-to-many>
        </set>
       
        <set name="emailAddresses" table="people_email_addr">
            <key column="people_id"></key>
            <element type="string" column="email_addr"></element>
        </set>
    </class>
</hibernate-mapping>