Need help with this sql statement in hibernate 2 weeks

kbarnes@sfa · **Joined:** Fri Sep 21, 2007 6:07 pm **Posts:** 3

String fuelTypes = "AND fuel_type in (''JP5'', ''JP8'', ''F76'')";

String sql = "SELECT DISTINCT MIN(dummy_key),state,dodaac,geoloc,country,is_primary_spod, is_secondary_spod, rowtocol('select fuel_type from " +
"mv_dodaac_facility_product where dodaac = ''' || mvdfp.dodaac || ''' " + fuelTypes + "')fuel_list "+
"FROM mv_dodaac_facility_product mvdfp GROUP BY state,geoloc,country,is_primary_spod,is_secondary_spod"+
" ORDER BY country,state";

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

what is the question here?

kbarnes@sfa · **Joined:** Fri Sep 21, 2007 6:07 pm **Posts:** 3

I want to return
List x = session.createcriteria(X.class).createcriteria("K").distinct.separateBy,

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

For aggregate functions, first do your criteria normally, then use a projection (reference documentation 15.7).