title: Set the value in a column within a SELECT query
body: <p>I have two (simplified) tables as follows:</p>
  <p>Table AAPT</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Well</th>
  <th>Type</th>
  <th>Comment</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A</td>
  <td>PT</td>
  <td>Good</td>
  </tr>
  <tr>
  <td>B</td>
  <td>PT-S</td>
  <td>Average</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Table AASPIN</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Well</th>
  <th>Type</th>
  <th>Remark</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A</td>
  <td>PT</td>
  <td>Bad</td>
  </tr>
  <tr>
  <td>B</td>
  <td>PT-S</td>
  <td>Fair</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to run a SELECT query that results in the following:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Well</th>
  <th>Type</th>
  <th>Comment</th>
  <th>Remark</th>
  <th>PTType</th>
  <th>SpinType</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A</td>
  <td>SPINPT</td>
  <td>Good</td>
  <td>Bad</td>
  <td>PT</td>
  <td>SPIN</td>
  </tr>
  <tr>
  <td>B</td>
  <td>SPINPT</td>
  <td>Average</td>
  <td>Fair</td>
  <td>PT-S</td>
  <td>SPIN-PT</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I use both MS Access and SQL-Server.</p>
  <p>In Access, I use the following query:</p>
  <pre><code>SELECT A.Well, A.Type, A.Comment, B.Remark, A.Type AS PTType, B.Type AS SpinType
  FROM AAPT A, AASPIN B
  WHERE A.Well = B.Well
  </code></pre>
  <p>However, I do not know how to set the value of the Type column to &quot;SPINPT&quot;</p>
  <p>Any suggestions?</p>