select t1.*, t2.* from table1 t1 left join table2 on table1.id = table2.table1_id and table2.some_field = ? where t1.id = ?

select t1 from mypackage.MyClass t1 left join fetch t1.collectionОfT2 with t2.someField = ? where t1.id = ?

select {t1.*}, {t2.*} from table1 t1 left join table2 on table1.id = table2.table1_id and table2.some_field = ? where t1.id = ?

session.createSQLQuery(sql).addEntity("t1", MyClass. class ).addJoin("t2", "t1.collectionОfT2").setParameter( 0 , value).setParameter( 1 , id).uniqueResult();

session.createSQLQuery(sql).addEntity("t1", MyClass. class ).addJoin("t2", "t1.collectionОfT2").setParameter( 0 , value).setParameter( 1 , id).list();

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping auto-import="false">
    <class name="mypackage.entity.Parent" table="PARENT">
        <id name="id" column="ID" type="long" unsaved-value="null">
            <generator class="native"/>
        </id>
        <property name="name" column="NAME" type="string" length="127" not-null="true"/>
        <set name="children" table="CHILD" inverse="true" cascade="save-update">
            <key column="PARENT_ID"/>
            <one-to-many class="mypackage.entity.Child"/>
        </set>
    </class>
</hibernate-mapping>

 package  mypackage.entity;

 import  java.io.Serializable;
 import  java.util.LinkedHashSet;
 import  java.util.Set;

 public   class  Parent  implements  Serializable {

     private   Long  id;
     private  String name;
     private  Set children =  new  LinkedHashSet();

     public   Long  getId() {
         return  id;
    }
     public   void  setId( Long  id) {
         this .id = id;
    }
     public  String getName() {
         return  name;
    }
     public   void  setName(String name) {
         this .name = name;
    }
     public  Set getChildren() {
         return  children;
    }
     public   void  setChildren(Set children) {
         this .children = children;
    }
     public   void  addChild(Child child) {
         this .children.add(child);
        child.setParent( this );
    }
}

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping auto-import="false">
    <class name="mypackage.entity.Child" table="CHILD">
        <id name="id" column="ID" type="long" unsaved-value="null">
            <generator class="native"/>
        </id>
        <property name="name" column="NAME" type="string" length="127" not-null="true"/>
        <many-to-one name="parent" column="PARENT_ID" class="mypackage.entity.Parent" not-null="true"/>
    </class>
</hibernate-mapping>

 package  mypackage.entity;

 public   class  Child {

     private   Long  id;
     private  String name;
     private  Parent parent;

     public   Long  getId() {
         return  id;
    }
     public   void  setId( Long  id) {
         this .id = id;
    }
     public  String getName() {
         return  name;
    }
     public   void  setName(String name) {
         this .name = name;
    }
     public  Parent getParent() {
         return  parent;
    }
     public   void  setParent(Parent parent) {
         this .parent = parent;
    }
}