Relatively new to Teradata - am trying to insert a row with static (hard-coded) fields into a query result table. I've been able to successfully create 2 CTE tables per below - I just can't figure out the syntax to insert 1 table into the other. Feels like this is very close to the solution I want - just can't seem to figure out the correct syntax for the insert into. Thanks for you help in advance!
with temp_table1 as (
select cola, colb, colc from dbo.table), --desired query table
temp_table2 (cola, colb,colc) as ('static_val1' cola, 'static_val2' colb, 'static_val3' colc) --desired static values to insert
insert into temp_table1 select * temp_table2; --  Syntax error, expected something like a 'SELECT' keyword...
What are you actually trying to do?
You can't insert rows into a CTE (and you probably don't want to insert it into the base table).
You might UNION a row, but Teradata does not support VALUES and requires a FROM for set operations:
with temp_table1 as ( select cola, colb, colc from dbo.table union all select 'static_val1', 'static_val2', 'static_val3' from (select 1 as x) as dt -- this is just a dummy because FROM must be used ) select * from temp_table1