title: SQL - Converting one value into two or more possible values
body: <p>I have one table I would like to convert into another set of values.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Table A's Letter Column</th>
  <th>Converts into</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A</td>
  <td>AA AND AB</td>
  </tr>
  <tr>
  <td>B</td>
  <td>BB</td>
  </tr>
  <tr>
  <td>C</td>
  <td>CC</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>So, what I am doing is...</p>
  <ol>
  <li>SELECT all the values from Table A</li>
  <li>Convert Table A's values using a CASE</li>
  </ol>
  <pre><code>CASE TABLE A COLUMN
   WHEN 'A' THEN 'AA'
   WHEN 'A' THEN 'AB'
   WHEN 'B' THEN 'BB'
   WHEN 'C' THEN 'CC'
   ELSE NULL
  END
  </code></pre>
  <p>Of course, a CASE statement can only have one outcome and thus I can't get it show both 'AA' and 'AB' when it converts 'A' from Table A. What can I do in this situation?</p>
  <p>The expected outcome I want is that it would show (AA, AB, BB, and CC) using the input of (A, B, and C).</p>
  <p>Let me know if this sounds confusing!
  Thank you!</p>
  <p>EDIT: For clarification... I modified the orignal above and added details below.</p>
  <ol>
  <li>I have three values that I pulled from one table using a SELECT.</li>
  <li>I want these three values to be shown in the converted form as 'AA', 'AB', 'BB', and 'CC'.</li>
  </ol>