SQL to Add Another Year's Data

[jbaldo]

SELECT m.program_id, m.goal_id, m.site, m.function_id, m.lcap_id, m.object_id, m.year, m.sacs_obj_id, m.adopted_budget, m.working_budget, m.encumbrance, m.ytd_actual, m.balance, m.org_key, m.org_key_description, m.omaj_description FROM measure_g_actuals_2017 m

UNION ALL

SELECT a.program_id, a.goal_id, a.site, a.function_id, a.lcap_id, a.object_id, a.year, a.sacs_obj_id, a.adopted_budget, a.working_budget, a.encumbrance, a.ytd_actual, a.balance, a.org_key, a.org_key_description, a.omaj_description FROM measure_g_actuals a