#IT-6203
Awesome StudentQuestion • Database Management System 2 (Oracle 10g Admin)
Supposed that table: Workers and Employees is consists of the following values.
Answer
INSERT INTO EMPLOYEES(ID, LASTNAME, DEPARTMENT)SELECT ID, LASTNAME, DEPARTMENTFROM WORKERSWHERE STATUS = ‘Regular’;