SQLQuery query = session.createSQLQuery(
        "select c.cust_id as cid, " +
        "     c.cust_name as cname, " +
        "     o.order_id as oid, " +
        "     o.order_num as onum " +
        " from customer c " +
        "     inner join orders o " +
        "         on c.cust_id = o.cust_id"
);
query.addRoot( "c", Customer.class )
        .addPropertyMapping( "id", "cid" )
        .addPropertyMapping( "name", "cname" );
query.addFetch( "o", "c", "orders" )
        .addPropertyMapping( "id", "oid" )
        .addPropertyMapping( "orderNumber", "onum" );