Calculations using a Union query
Calculations using a Union query
(OP)
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
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
RE: Calculations using a Union query
CODE --> SQL
Hope This Helps, PH.
FAQ219-2884: How Do I Get Great Answers To my Tek-Tips Questions?
FAQ181-2886: How can I maximize my chances of getting an answer?
RE: Calculations using a Union query