foxpro-select

result in the column , e.g. code , o/s . onhand

select code, sum(qty) , sum(iif(code='a',qty,0 ))  as a , sum(iif(code='b',qty,0 )) as b ,  sum(iif(code='c',qty,0 ))  c from tempaa