Fecha del Tema: 2013-05-04 12:43:57

EJEMPLO:
INSERT INTO managers (id, name, salary, hiredate)
        SELECT empno, ename, sal, hiredate
        FROM emp
      WHERE job=â??MANAGERâ??