title: Insert columns from another table as well as text
body: <p>So here's the thing my target table (T) and source table (S) look like this.</p>
  
  <pre><code>+----+----+ 
  | T  | S  | 
  +----+----+ 
  | PO | PO | 
  | VE | VE | 
  | TE |    | 
  +----+----+
  </code></pre>
  
  <p>I need a script that will insert the columns from the source into target and in the TE field I need it to insert the text "source1"</p>
  
  <p>I've been playing around (unsuccessfully) with this:</p>
  
  <pre><code>insert into target
     (PO, VE, TE)
     select PO, VE, 'source1' from source
  </code></pre>
  
  <p>thank you in advance for helping, much appreciated</p>