I was wondering if there was a way to get the totals from multiple tables and put the values in one table.
Example: I want to count the distinct row_nums from each table as in the statements below and have the results in one table.
Select COUNT(distinct row_num) AS TOTAL_HIP_MEDICAID from ALL_CLAIMS;
Select COUNT(distinct row_num) AS TOTAL_MATCHED_CLAIMS from MATCHED_CLAIMS;
Select COUNT(distinct row_num) AS NOT_MATCHED_CLAIMS from NOT_MATCHED;