SQLQuery query = session.createSQLQuery("select * from A);
   query.addEntity(A.class);
   List list  = query.list();

   A.hbm.xml
   <many-to-one
        class="B"
        fetch="select" name="b" lazy="no-proxy">
        <column name=b_ID" />
    </many-to-one>