SELECT "ELEMENT_REPORTING_NAME","CLASSIFICATION_NAME","PAYMENT","PROCESSING_PRIORITY","ASSIGNMENT_ACTION_ID","ASSIGNMENT_ID" FROM pay_nz_soe_run_elements_v1 UNION ALL SELECT "ELEMENT_REPORTING_NAME","CLASSIFICATION_NAME","PAYMENT","PROCESSING_PRIORITY","ASSIGNMENT_ACTION_ID","ASSIGNMENT_ID" FROM pay_nz_soe_run_elements_v2
SELECT "ELEMENT_REPORTING_NAME"
, "CLASSIFICATION_NAME"
, "PAYMENT"
, "PROCESSING_PRIORITY"
, "ASSIGNMENT_ACTION_ID"
, "ASSIGNMENT_ID"
FROM PAY_NZ_SOE_RUN_ELEMENTS_V1 UNION ALL SELECT "ELEMENT_REPORTING_NAME"
, "CLASSIFICATION_NAME"
, "PAYMENT"
, "PROCESSING_PRIORITY"
, "ASSIGNMENT_ACTION_ID"
, "ASSIGNMENT_ID"
FROM PAY_NZ_SOE_RUN_ELEMENTS_V2
|
|
|