title: SQL: How to move columns into another table whilst also adding extra entires?
body: <pre><code>INSERT INTO Bookings (departing, arriving, departure_date, departure_time, arrival_time, price)
      SELECT depart_from, arrive_in, travel_date, departure_time, arrival_time, price
      FROM train
      WHERE (train_ID = @p_ID_choice);
  </code></pre>
  
  <p>Above is a query that takes several columns from a table called "train" and inserts them into another called "booking".</p>
  
  <p>I would like to add to that query that it should also insert the string "manager" into a column called "user_type". The string "manager" does not exist in the table I am copying from, I simply wish to add it to the query.</p>