Question: The table with the 2 rows of data is Emp_1 Expected Results EMPHIREDATE 2000-11-08 JOB-CODE 502 EMP-INITIAL EMPFNAME John David EMPLNAME EMP,NUM 101 102 News
The table with the 2 rows of data is Emp_1 Expected Results EMPHIREDATE 2000-11-08 JOB-CODE 502 EMP-INITIAL EMPFNAME John David EMPLNAME EMP,NUM 101 102 News 1989-07-12 501 or Actual Results EMP NUM EMP LNAMEEMP FNAME EMP INITIAL EMP HIREDATE JOB CODE 101 102 News John 2000-11-08 502 Senior David 1989-07-12 501 Problem 3 using the EMPLOYEE table that already exists, use a subquery to insert the remaining rows from the EPPLovef table into the ap" table Remember your subquery should only retrieve the columns needed for the ERPa table and only the employees shown in the figure compne Problem 3 above
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
