title: INSERT into a table using a select statement for 1 of the columns. All other columns are predefined
body: <p>I am trying to insert into a table with set values for all the columns except 1. On the final column I want to loop through a column from another table with a select statement.</p>
  
  <pre><code>INSERT INTO bla_bla 
  SELECT "PRE", "DEFINED", col1
  FROM table_2
  </code></pre>