title: SQL - Creating a joined temp table
body: <p>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:</p>
  
  <pre><code>select program, event
  from OMEGA.HP
  inner join POM.GT
  on program = substring(name,7,4)
  where LENGTH(name)= 25
  </code></pre>
  
  <p>What is the easiest way to create a temp table for the above?</p>