SELECT
m.match_type,
count(m.match_type)
cat.description,
loc.oid

FROM
USER_MATCH m,
RECORD rec,
CATEGORY cat,
LOCATION loc

WHERE
m.record_oid = rec.oid and
rec.category_oid = cat.oid and
rec.location_oid = loc.oid
group by m.match_type, cat.description, loc.oid

Criteria criteria = hibernateTemplate.getSessionFactory().getCurrentSession().createCriteria(Match.Class);
        criteria.createAlias("record", "record");
        criteria.createAlias("category", "category");
       
        ProjectionList projList = Projections.projectionList();       
        projList.add(Projections.groupProperty("record.categoryId")); 
        projList.add(Projections.groupProperty("record.locationId"));
        criteria.setProjection(projList);