SELECT ; SUM(IIF(INLIST(UPPER(cstatus), "ENROLLED","LOSS", "PIF"), nloan_amount,0)) as Total_Amt_CAP_Loans, ; SUM(IIF(UPPER(cstatus) = "ENROLLED", nloan_amount,0)) as Total_Amt_Enrolled_Loans, ; SUM(IIF(INLIST(UPPER(cstatus), "ENROLLED","LOSS", "PIF"), nstate_reserve_payment,0)) as nBDC_Reserve, ; SUM(IIF(INLIST(UPPER(cstatus), "ENROLLED","LOSS", "PIF"), nborrower_reserve_payment+nlender_reserve_payment,0)) as nBank_Borrower_Reserve, ; (SELECT SUM(ytotal_claim_amount) FROM claims.dbf) as nClaims_Paid ; FROM loan.dbf>How can I combine the following into one SQL statement? The problem I am having is the majority of the data is coming from one table, but the criteria for each field is different.