It's a strange concept, but the zero's have to have the same structure as the field. Think of it as a picture clause :o)
sele svc, size, atr, ;
sum(iif(atr = 'CB03', amount, 0.00)) as b03amt, ;
sum(iif(atr = 'CB02', amount, 0.00)) as b02amt, ;
sum(iif(atr = 'CB01', amount, 0.00)) as b01amt, ;
sum(iif(atr = 'CB01', qty, 0.00)) as b01qty,;
sum(iif(atr = 'CB02', qty, 0.00)) as b02qty,;
sum(iif(atr = 'CB03', qty, 0.00)) as b03qty;
from junk3 into cursor cuCharges_sum ;
group by svc, size order by svc
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement