Example: Specifying a TABLE Function in the FROM Clause - 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;