SELECT Pay_Grade , Pay_Grade_Id , Emp_Id , Business_Group_Id , Date_From , Date_To from PQH_DE_RR_GRADE1_V union select Pay_Grade , Pay_Grade_Id , Emp_Id , Business_Group_Id , Date_From , Date_To from PQH_DE_RR_GRADE2_V
SELECT PAY_GRADE
, PAY_GRADE_ID
, EMP_ID
, BUSINESS_GROUP_ID
, DATE_FROM
, DATE_TO
FROM PQH_DE_RR_GRADE1_V UNION SELECT PAY_GRADE
, PAY_GRADE_ID
, EMP_ID
, BUSINESS_GROUP_ID
, DATE_FROM
, DATE_TO
FROM PQH_DE_RR_GRADE2_V
|
|
|