Data obtained from a SQL-derived table can be inserted into a new table.
select pubdate into pub_dates from (select pubdate from titles) dt_e where pubdate = "450128 12:30:1PM"
Data from the SQL-derived table dt_e is inserted into the new table pub_dates.