TABLE Option Examples | SQL SELECT Statements | Teradata Vantage - Example: Specifying a TABLE Function in the FROM Clause - Analytics Database - Teradata Vantage

The following statement inserts all of the rows that the sales_retrieve table function produces into salestable:

     INSERT INTO salestable
     SELECT s.store, s.item, s.quantity
     FROM TABLE (sales_retrieve(9005)) AS s;