Hi,
I have the following table:

INOUT Total
1 3
2 2
2 4
1 3
2 6
1 23
2 33

I want to make a query that will do the following:

Subtract (the sum of the total where inout=1) from (the sum of the
total where inout=2)

Any help is greatly appreciated. Thanks

SELECT
SUM(
CASE inout
WHEN 1 THEN -total
WHEN 2 THEN total
END)
FROM YourTable

--
David Portas
SQL Server MVP
--

Thanks David.
It works