para que el group by funcione tienes que poner todos los parametros del select no solo uno
SELECT DISTINCT Ordenes.TIPO, Ordenes.NO_ORDEN, Ordenes.NO_LOTE, Ordenes.CODIGO, Insutemp.DESCRIP, (Acodef.OBT2 * 100) / Ordenes.CANT_TEO as Rendimient, Ordenes.F_FARMA, Ordenes.CANT_TEO, Acodef.OBT2
FROM "ORDENES.DBF" Ordenes
INNER JOIN ":Inventarios:insutemp.dbf" Insutemp
ON (Ordenes.CODIGO = Insutemp.COD_INSUMO)
INNER JOIN ":CostosAct:ACODEF.DBF" Acodef
ON (Ordenes.NO_ORDEN = Acodef.ORDEN)
WHERE Ordenes.TIPO = 'A'
GROUP BY Ordenes.TIPO, Ordenes.NO_ORDEN, Ordenes.NO_LOTE, Ordenes.CODIGO, Insutemp.DESCRIP, Ordenes.F_FARMA, Ordenes.CANT_TEO, Acodef.OBT2
|