hibernate左连接

try { 
Session session = HibernateSessionFactory.getSession();
String queryString = "select a.id as col1,b.name as col2 from table_name1 a left join table_name2 b on a.id=b.id";//sql语句
Query queryObject = session.createSQLQuery(queryString).addScalar("col1", Hibernate.LONG).addScalar("col2", Hibernate.STRING); //createSQLQuery
List list = queryObject.list();
List list1 =  new ArrayList();
for(int i=0;i<list.size();i++)
{
Object[] object = (Object[]) list.get(i); 
   TableNmme1 model = new TableNmme1(); //java对象
model.setId(new Long(object[0].toString()));
model.setName(object[1]==null?"":object[1].toString());
list1.add(model);
}
return list1;
} catch (HibernateException ex) {
ex.printStackTrace();
log.error(ex);
throw new HibernateException(ex);
} finally {
HibernateSessionFactory.closeSession();
}