title: insert combine (value and select)
body: <p>There are ways of inserting data into table:</p>
  
  <pre><code>insert into MyTable (ColA, ColB, ColC) values ('A', 'B', 'C')
  
  insert into MyTable (ColA, ColB, ColC) select  colAA, colBB, colCC from MyTable2
  </code></pre>
  
  <p>Is there way to use <code>insert into MyTable (ColA, ColB, ColC) select  colAA, colBB, colCC from MyTable2</code> but instead of inserting for example colAA value into colA I woulkd like to insert there always 1.</p>
  
  <p>THanks for help</p>