SQL question

Dear All,

I want to select the sum of all orders, but I want to subtract the all the sale reversals, i.e. all orders that where canceled out. Do I need to create a union like

create view test as
  select sum(amount) 'TotalO' from order where Type = 'S'   UNION
  select (sum(amount) * (-1)) 'TotalO' from order where Type = 'R'

select TotalO from test

OR is there a way of writing the select statement with an IF statement or a CASE statement?

TIA Henrik Staun Poulsen
InfoLog Received on Wed Sep 09 1998 - 08:04:14 CDT