Ciao a tutti!
ho un problemino con il group by, ho una query che senza il group by mi estrare il risultato coretto se io imposto il group by invece , no.....

la select ha parecchi campi perche sarebbe parte di una UNION:
select CO_CM_m.CMCODCOM as CodCOMMESSAtr, co_commesse.COMMDESCRIZIONE as DescrCOMMESSAtr,
cli.COTITLE as CLIENTE, cc_statiopp.DESCRIZIONEST as StatoCommessa,
CAST(co_commesse.DATAINIZIO AS date) as dInizioComm, CAST(co_commesse.DATAFINE AS date) as dFineComm,
CO_TIPCOM.DESTIP as TipoCommessa, acc.COTITLE as OpportLead,
pm.COTITLE as DeliveryLead, cc_livconf.DESCRIZIONELIV as LivelloConfidenza,
ba_busiunit.BUCODICE as BU, co_commesse.CENTRORICAVO,
CO_TPLCOM.DESTPL as TIPOLOGSERVIZIO, co_aoffering.DESOFF as OFFERING,
'' as dataInizioTR, '' as dataFineTR,
'0' as TRCODRISORSA,'' as TRRISORSA,
'' as DESCRQUALIFICA,'' as DATAFINERAPPORTO,
'0' as TRCODVOCEBUDGET, '' as TRVOCEBUDGET,
'0' as TRCODARTICOLO, '' as TRARTICOLO,
co_drollcostprofris.RCPROFILO as PROFILO, hr_profili.DESCRPROFILO as DESCRPROFILO,
CAST(co_drollcostprofris.RCCOSUNIT AS Decimal(9,2)) as CostoProfiloTR, '0' as TotCostoProfilo,
'0' as ToTGG_PROGRESSIVO, '0' as COSTOannoPianificato,
'0' as TotaleRM, '0' as RicavoAnno,
'0' as COSTO_CM_EROGATO,'0' as importoGM,
'0' as PercentualeGM ,'0' as Ricavo_Maturato,
'0' as COSTO_Maturato, '0' as GM_Maturato,
co_arollcost.RCCM as codCM,co_drollcostprofris.RCANN,
CO_CM_m.CMSEDE,ba_offices.OFDESCRI,
co_arollcost.RCREV as NumREV,CO_CM_m.CMAZI,
CAST (co_drollcostprofris.RCGEN AS Decimal(9,2))as genn, CAST (co_drollcostprofris.RCFEB AS Decimal(9,2))as feb,
CAST (co_drollcostprofris.RCMAR AS Decimal(9,2))as mar, CAST (co_drollcostprofris.RCAPR AS Decimal(9,2))as apr,
CAST (co_drollcostprofris.RCMAG AS Decimal(9,2))as magg, CAST (co_drollcostprofris.RCGIU AS Decimal(9,2))as giu,
CAST (co_drollcostprofris.RCLUG AS Decimal(9,2))as lug, CAST (co_drollcostprofris.RCAGO AS Decimal(9,2))as ago,
CAST (co_drollcostprofris.RCSET AS Decimal(9,2))as sett, CAST (co_drollcostprofris.RCOTT AS Decimal(9,2))as ott,
CAST (co_drollcostprofris.RCNOV AS Decimal(9,2))as nov, CAST (co_drollcostprofris.RCDIC AS Decimal(9,2))as dic,
CAST (co_drollcostprofris.RCQTARIGA AS Decimal(9,2))as totANNORigaCM
from CO_CM_m

la group by mi richiede tutti i campi tranne quelli a ZERO o vuoti.

cosa posso controllare?
ho provato a rifare la zero la query ri-ragionandola, ma tutto funziona se non cè il group by, come l'inserisco non mi estrae piu tutto corretto.



Grazie...