SELECT expenditure_type_id , expenditure_type , revenue_category_code FROM pa_expenditure_types UNION ALL Select event_type_id , event_type , revenue_category_code FROM pa_event_types
View Text - HTML Formatted
SELECT EXPENDITURE_TYPE_ID , EXPENDITURE_TYPE , REVENUE_CATEGORY_CODE FROM PA_EXPENDITURE_TYPES UNION ALL SELECT EVENT_TYPE_ID , EVENT_TYPE , REVENUE_CATEGORY_CODE FROM PA_EVENT_TYPES