Hi all,

I would like to create an instruction in SQL to find the balance of products for customers,and then print the result

My table Movements of Stock (MOV_STK) with field

cod_mov < = 50 In Stock
cod_mov > = 50 Out Stock

Some Records

Cod.Mov   Ref.  Date    Customer Quant.
  05       01   01.01       1      50  -- In
  55       01   01.01       1      25  -- Out
  05       02   01.01       1      10
  55       02   01.01       1       5
  05       01   02.02       2      10
  55       01   02.02       2       5

The Report like this

Customer 1 
     Ref 01 Balance 25
     ref 02 Balance  5
Customer 2
     Ref 01 Balance  5, Etc,

Thank's

João Batista