SELECT BILL_YEAR, BILL_NO, BILL_TYPE, DUE_DATE, ADV_TAX AS ORIGINAL_TAX_DUE, TOTAL AS TOTAL_BILL_AMOUNT, BALANCE_DUE AS CURRENT_AMT_DUE FROM DY2022.DBO.BILL WHERE BILL_TYPE='P' AND PROPERTYKEY IN (SELECT PROPERTYKEY FROM DY2022.DBO.PROPERTY_ITEMS WHERE DIGSTRAT='A') UNION 
SELECT BILL_YEAR, BILL_NO, BILL_TYPE, DUE_DATE, ADV_TAX AS ORIGINAL_TAX_DUE, TOTAL AS TOTAL_BILL_AMOUNT, BALANCE_DUE AS CURRENT_AMT_DUE FROM DY2021.DBO.BILL WHERE BILL_TYPE='P' AND PROPERTYKEY IN (SELECT PROPERTYKEY FROM DY2021.DBO.PROPERTY_ITEMS WHERE DIGSTRAT='A')  

