inner join - SQL - Creating a joined temp table -

i looking join 2 tables temp table, use temp table in select query. select statement temp table want create:

select program, event omega.hp inner join pom.gt on program = substring(name,7,4) length(name)= 25 

what easiest way create temp table above?

select program, event #temp    --------------------------------check here omega.hp inner join pom.gt on program = substring(name,7,4) length(name)= 25