title: Adding an Column Populated by an Arbitrary Value in SQL
body: <p>Basically, I have a query that returns 2 columns:</p>
  
  <pre><code>SELECT ACTION_LOG_ID, COMMUNICATIONS_ID
  FROM consumer_action_log
  WHERE COMM_TYPE_ID=4
  </code></pre>
  
  <p>To every row in the result set for this query, I want to add the value 234 titled Customer_ID. Here was my best attempt:</p>
  
  <pre><code>SELECT ACTION_LOG_ID, COMMUNICATIONS_ID
  FROM consumer_action_log
  WHERE COMM_TYPE_ID=4
  UNION 
  SELECT CONSUMER_ID,CONSUMER_FIRST_NAME
  FROM consumer_profile
  WHERE CONSUMER_ID=234;
  </code></pre>
  
  <p>Note: the result of the second half of the query will always be 234. I am using MySQL.</p>