Example: Specifying a TABLE Function in the FROM Clause - Teradata Database - Teradata Vantage NewSQL Engine

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;