buenos dias
no sabia que titulo poner..
tengo esta consulta
Código SQL
[-]
Select D.KOD, A.Descl,
(Case when C.TipoConsumo = 'K' then Sum (D.Cant) else 0 end) As CantCred,
(Case when C.TipoConsumo = 'C' then Sum (D.Cant) else 0 end) As CantCont
From tblconsumod d
left join tblconsumoc c on d.tdc+d.doc = c.tdc + c.doc
Left Join tblArticulo a on D.kod = A.KOD
where c.f_doc = '17/06/2011' and c.TipoConsumo in ('K','C')
group by D.KOD, A.Descl, C.TipoConsumo
Order by D.KOD
y me muestra estos datos
Cita:
KOD......Descl.....CantCred.....CantCont....
00002....Menu......10.................0
00002....Menu.......0..................5
|
me gustaria que se muestre asi
Cita:
KOD......Descl.....CantCred.....CantCont....
00002....Menu......10.................5
|
alguna idea?