Is there a SELECT statement to subtract rows of the same column?
If I understood your question correctly...

SELECT mem_id, 
       Sum(CASE TranType 
             WHEN 'C' THEN Amount 
             WHEN 'D' THEN -Amount 
           END) AS Amount_Owed 
FROM   YourTable 
GROUP  BY mem_id;