This is the query. I am trying to sum up the amt allowed. What is happening rite now is it stays separate. Any help would be appreciated!
SELECT SUM(AMT_ALLOWED) allowed, SUM(UNITS_NOT_DENIED) units, SUM(case when proc_modifier<>'26' then units_not_denied else 0 end) encounters, SERVICE_DATE.QUARTER
FROM ALL_CLAIMS, SERVICE_DATE, Provider
WHERE DATE_OF_SERVICE = DATE
AND DATE_OF_SERVICE BETWEEN '20060101' AND '20060630'
AND ALL_CLAIMS.denied_flag = 'N'
AND ALL_CLAIMS.last_version_flag = 'Y'
AND ALL_CLAIMS.PROVIDER_CAT <> '02'
AND ALL_CLAIMS.BUSINESS_LINE_KEY IN ('0001','0002','0003','0013','0032','0080','0081', '0093')
AND (all_claims.tos_code IN ('115','112','184')
OR all_claims.procedure_code BETWEEN 'C0078460' AND 'C0078496'
OR all_claims.procedure_code IN ('C0078890','C0078990'))
AND TAHP_POS_CODE NOT In ('01','13','08')
AND ALL_CLAIMS.PROVIDER_ID = Provider.PROVIDER_ID
AND ALL_CLAIMS.IPA IN ('02','04','05','10','17','29','48','52','55','64' ,'79','P2','P3','P6','P7','P8','P9','Q0','Q1','Q2' ,'Q3')
GROUP BY SERVICE_DATE.QUARTER
UNION
SELECT SUM(SPP_AMOUNT) allowed, SUM(UNITS_NOT_DENIED) units, SUM(case when proc_modifier<>'26' then units_not_denied else 0 end) encounters, SERVICE_DATE.QUARTER
FROM ALL_CLAIMS_AND_RISK_SPP, SERVICE_DATE, Provider
WHERE DATE_OF_SERVICE = DATE
AND DATE_OF_SERVICE BETWEEN '20060101' AND '20060630'
AND ALL_CLAIMS_AND_RISK_SPP.denied_flag = 'N'
AND ALL_CLAIMS_AND_RISK_SPP.last_version_flag = 'Y'
AND ALL_CLAIMS_AND_RISK_SPP.PROVIDER_CAT <> '02'
AND ALL_CLAIMS_AND_RISK_SPP.BUSINESS_LINE_KEY IN ('0001','0002','0003','0013','0032','0080','0081', '0093')
AND (ALL_CLAIMS_AND_RISK_SPP.tos_code IN ('115','112','184')
OR ALL_CLAIMS_AND_RISK_SPP.procedure_code BETWEEN 'C0078460' AND 'C0078496'
OR ALL_CLAIMS_AND_RISK_SPP.procedure_code IN ('C0078890','C0078990'))
AND TAHP_POS_CODE NOT In ('01','13','08')
AND ALL_CLAIMS_AND_RISK_SPP.PROVIDER_ID = Provider.PROVIDER_ID
AND ALL_CLAIMS_AND_RISK_SPP.IPA IN ('02','04','05','10','17','29','48','52','55','64' ,'79','P2','P3','P6','P7','P8','P9','Q0','Q1','Q2' ,'Q3')
GROUP BY SERVICE_DATE.QUARTER