USE Study GO INSERT INTO EMPTEST SELECT * FROM EMPLOYEE WHERE DNO = 30