Example: Insert Using a SELECT Subquery without Target Column List - Teradata VantageCloud Lake

The INSERT operation performed in the previous example can also be accomplished by the following statement. A column name list is not given for the promotion table; therefore, the employee columns referenced in the SELECT subquery must match, in both quantity and sequence, the columns contained by promotion.

     INSERT INTO promotion
     SELECT name, deptno, yrsexp
     FROM employee
     WHERE yrsexp > 10 ;