title: I want to insert from a select statement using union ALL
body: <p>I want to use union on a query while inserting records in a table. The insert is also having some hard coded values. Rest of the values are coming from the union.
  eg..</p>
  
  <pre><code>INSERT INTO my_test_one (name, sirname, Dept)
  VALUES
    ((select 'name1','sirname1', Dept FROM my_test_one_backup WHERE dept = 500 
      union all
      select 'name1','sirname1', Dept FROM my_test_one_backup WHERE dept = 501 ));
  </code></pre>