SELECT "ROW_ID","ASSIGNMENT_ID","TIME_PERIOD_ID","ELEMENT_REPORTING_NAME","START_DATE","END_DATE","ABSENCE_HOURS","PAYMENT" FROM pay_au_asg_leave_taken_v1 UNION SELECT "ROW_ID","ASSIGNMENT_ID","TIME_PERIOD_ID","ELEMENT_REPORTING_NAME","START_DATE","END_DATE","ABSENCE_HOURS","PAYMENT" FROM pay_au_asg_leave_taken_v2 UNION SELECT "ROW_ID","ASSIGNMENT_ID","TIME_PERIOD_ID","ELEMENT_REPORTING_NAME","START_DATE","END_DATE","ABSENCE_HOURS","PAYMENT" FROM pay_au_asg_leave_taken_v3 UNION ALL SELECT "ROW_ID","ASSIGNMENT_ID","TIME_PERIOD_ID","ELEMENT_REPORTING_NAME","START_DATE","END_DATE","ABSENCE_HOURS","PAYMENT" FROM pay_au_asg_leave_taken_v4 UNION ALL SELECT "ROW_ID","ASSIGNMENT_ID","TIME_PERIOD_ID","ELEMENT_REPORTING_NAME","START_DATE","END_DATE","ABSENCE_HOURS","PAYMENT" FROM pay_au_asg_leave_taken_v5
SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_HOURS"
, "PAYMENT"
FROM PAY_AU_ASG_LEAVE_TAKEN_V1 UNION SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_HOURS"
, "PAYMENT"
FROM PAY_AU_ASG_LEAVE_TAKEN_V2 UNION SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_HOURS"
, "PAYMENT"
FROM PAY_AU_ASG_LEAVE_TAKEN_V3 UNION ALL SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_HOURS"
, "PAYMENT"
FROM PAY_AU_ASG_LEAVE_TAKEN_V4 UNION ALL SELECT "ROW_ID"
, "ASSIGNMENT_ID"
, "TIME_PERIOD_ID"
, "ELEMENT_REPORTING_NAME"
, "START_DATE"
, "END_DATE"
, "ABSENCE_HOURS"
, "PAYMENT"
FROM PAY_AU_ASG_LEAVE_TAKEN_V5
|
|
|