Calculations using a Union query 1

[Stewman]

Hello,

I have a query consisting of 3 queries all union-ed together each returning a specific count. My end result looks like this:

Kount Type
786 Duplicates
11737 Orders
38503 Calls

What I want is to do the following calculation within this sql query.

(Calls + Orders) - Duplicates

Is this possible?

Thanks,

Chris

 

[PHV]

One way:

SELECT SUM(Kount*CASE WHEN Type='Duplicates' THEN  -1 ELSE 1 END) AS CalculatedAmount
FROM yourUnionQuery

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Stewman]

Thanks PHV it worked great. Exactly what I wanted.