title: Select a dummy column with a dummy value in SQL?
body: <p>I have a table with the following </p>
  
  <pre><code>Table1
  col1   col2
  ------------
   1      A 
   2      B
   3      C
   0      D
  </code></pre>
  
  <p>Result</p>
  
  <pre><code>col1   col2  col3
  ------------------
  0       D     ABC
  </code></pre>
  
  <p>I am not sure how to go about writing the query , col1 and col2 can be selected by this</p>
  
  <pre><code>select col1, col2 from Table1 where col1 = 0;
  </code></pre>
  
  <p>How should I go about adding a col3 with value ABC.  </p>