Forum Discussion
Solved
Help with a Union Query
Hello, I am pretty new to Union Queries and am looking for some help. I have 2 pretty simple queries that bring back the Count of Distinct SSNs from 2 different places by plan #. The goal of my unio...
- can you first Create a Union query without Totaling:
SELECT Subquery_AdvDetailPPNTSContrib1.[Plan No], Subquery_AdvDetailPPNTSContrib1.[Soc Sec #]
FROM Subquery_AdvDetailPPNTSContrib1
UNION ALL
SELECT Subquery_AdvDetailPPNTSContribFlatDollar1.[Plan No], Subquery_AdvDetailPPNTSContribFlatDollar1.[Soc Sec #]
FROM Subquery_AdvDetailPPNTSContribFlatDollar1
Then create your Total Query from the above query.
can you first Create a Union query without Totaling:
SELECT Subquery_AdvDetailPPNTSContrib1.[Plan No], Subquery_AdvDetailPPNTSContrib1.[Soc Sec #]
FROM Subquery_AdvDetailPPNTSContrib1
UNION ALL
SELECT Subquery_AdvDetailPPNTSContribFlatDollar1.[Plan No], Subquery_AdvDetailPPNTSContribFlatDollar1.[Soc Sec #]
FROM Subquery_AdvDetailPPNTSContribFlatDollar1
Then create your Total Query from the above query.
SELECT Subquery_AdvDetailPPNTSContrib1.[Plan No], Subquery_AdvDetailPPNTSContrib1.[Soc Sec #]
FROM Subquery_AdvDetailPPNTSContrib1
UNION ALL
SELECT Subquery_AdvDetailPPNTSContribFlatDollar1.[Plan No], Subquery_AdvDetailPPNTSContribFlatDollar1.[Soc Sec #]
FROM Subquery_AdvDetailPPNTSContribFlatDollar1
Then create your Total Query from the above query.