#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’;