title: redundant rows are then in answer
body: <pre><code>SELECT item_id,
         CREDITBAL= (SELECT Sum(quantity)
                     FROM   axi_quantity_registers
                     WHERE  from_where != 'OPENING'
                            AND transaction_type = 'C'),
         OPENBAL = (SELECT Sum(quantity)
                    FROM   axi_quantity_registers
                    WHERE  from_where = 'OPENING'),
         DEBITBAL = (SELECT Sum(quantity)
                     FROM   axi_quantity_registers
                     WHERE  transaction_type = 'D')
  FROM   axi_quantity_registers 
  </code></pre>