| 
 | 
 
A table has three fields: a, b, and c. When b is empty, the meaning of a is "A". When b is not empty, the meaning of a is "B". Now I want Take out these two meanings at the same time and group them in C. How to take them? 
I.e. the result column I took should be: 
field c sum of field a representing "A" sum of field a representing "B" 
c1 a1 a11 
c2 a2 a22 
 
 
By the way, my database is sysbase |   
 
 
 
 |