FUNCION AGREGADO
Publicado por jaxc (1 intervención) el 20/09/2007 18:03:16
maness.. tengo la siguiente consulta sql.. la cual me funciona perfectamente.. el proble es cuando deseo agregar un campo.. me vota el error EL CAMPO NO FORMA PARTE DE LA FUNCION AGREGADO... no c k hacer:
ORIGINAL:
SELECT SERIE, tDOC_NO,T_DOC, FECHA ,MIN(NRO_DOC) AS DEL, MAX(NRO_DOC) AS AL,SUM(TOT) AS DeTOT,SUM(TOT_IMP) AS IMP,SUM(TOT_IGV) AS IGV,"Del " & [Del] & " al " & [Al] AS Numero, IIF( ((TDOC_NO = "03") OR (TDOC_NO = "12") ), Numero, T_DOC) FROM REGVENTAS WHERE (MES = ?) AND (ANO = ?) and (TDOC_NO="03" ) GROUP BY FECHA, TDOC_NO,T_DOC, SERIE ORDER BY TDOC_NO,SERIE, FECHA
DESEO HACER:
SELECT SERIE, dia, tDOC_NO,T_DOC, FECHA ,MIN(NRO_DOC) AS DEL, MAX(NRO_DOC) AS AL,SUM(TOT) AS DeTOT,SUM(TOT_IMP) AS IMP,SUM(TOT_IGV) AS IGV,"Del " & [Del] & " al " & [Al] AS Numero, IIF( ((TDOC_NO = "03") OR (TDOC_NO = "12") ), Numero, T_DOC) FROM REGVENTAS WHERE (MES = ?) AND (ANO = ?) and (TDOC_NO="03" ) GROUP BY FECHA, TDOC_NO,T_DOC, SERIE ORDER BY TDOC_NO,SERIE, FECHA
X FA AYUDENME
ORIGINAL:
SELECT SERIE, tDOC_NO,T_DOC, FECHA ,MIN(NRO_DOC) AS DEL, MAX(NRO_DOC) AS AL,SUM(TOT) AS DeTOT,SUM(TOT_IMP) AS IMP,SUM(TOT_IGV) AS IGV,"Del " & [Del] & " al " & [Al] AS Numero, IIF( ((TDOC_NO = "03") OR (TDOC_NO = "12") ), Numero, T_DOC) FROM REGVENTAS WHERE (MES = ?) AND (ANO = ?) and (TDOC_NO="03" ) GROUP BY FECHA, TDOC_NO,T_DOC, SERIE ORDER BY TDOC_NO,SERIE, FECHA
DESEO HACER:
SELECT SERIE, dia, tDOC_NO,T_DOC, FECHA ,MIN(NRO_DOC) AS DEL, MAX(NRO_DOC) AS AL,SUM(TOT) AS DeTOT,SUM(TOT_IMP) AS IMP,SUM(TOT_IGV) AS IGV,"Del " & [Del] & " al " & [Al] AS Numero, IIF( ((TDOC_NO = "03") OR (TDOC_NO = "12") ), Numero, T_DOC) FROM REGVENTAS WHERE (MES = ?) AND (ANO = ?) and (TDOC_NO="03" ) GROUP BY FECHA, TDOC_NO,T_DOC, SERIE ORDER BY TDOC_NO,SERIE, FECHA
X FA AYUDENME
Valora esta pregunta
0