SQL - Creating a joined temp table

I am looking to join two tables into a temp table, then use the temp table in a select query. This is the select statement for the temp table I want to create:

select program, event
from OMEGA.HP
inner join POM.GT
on program = substring(name,7,4)
where LENGTH(name)= 25

What is the easiest way to create a temp table for the above?

SQL - Creating a joined temp table

3 Answers