Código
IfxDataAdapter dt = new IfxDataAdapter(" SELECT a.cdgo_prdcto ,a.nmbre_prdcto DESCRIPCION, SUM(b.cntdad)PMDIOVTA ,a.csto_rpscion CR, " + " a.clfccion_prmnnte P, a.clfccion_tmpral T,a.cdgo_brra EAN" + " from prdcto a , prmdio_vnta b " + " where estdo = 'A' " + " and a.cdgo_prdcto = b.cdgo_prdcto " + " group by 1,2,4,5,6,7 " + " order by 2 ", conexion); dt.Fill(dsdatos, "Datos");