title: Using SQL, How to "rename" integers with alphabetic values?
body: <p>I have a requirement where after joining a table I need the system to rename certain numeric values with their descriptions</p>
  <p>For instance:</p>
  <p>When I execute the following query:</p>
  <p>select * from order_type and the results show as below:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Order Name</th>
  <th>order_Type</th>
  <th>Date</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A1</td>
  <td>1</td>
  <td>01/12/2021</td>
  </tr>
  <tr>
  <td>A2</td>
  <td>1</td>
  <td>01/12/2021</td>
  </tr>
  <tr>
  <td>B3</td>
  <td>2</td>
  <td>01/05/2021</td>
  </tr>
  <tr>
  <td>B5</td>
  <td>1</td>
  <td>01/04/2021</td>
  </tr>
  <tr>
  <td>C7</td>
  <td>2</td>
  <td>12/29/2020</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Unfortunately the way the system is designed the order type has no descriptor. SO is there any way to say</p>
  <p>Order_Type value '1' = Make.......
  Order_Type Value '2' = Buy</p>
  <p>so when someone runs the query again they see the below:</p>
  <p>select * from order_type and the results show as below:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Order Name</th>
  <th>order_Type</th>
  <th>Date</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>A1</td>
  <td>Make</td>
  <td>01/12/2021</td>
  </tr>
  <tr>
  <td>A2</td>
  <td>Make</td>
  <td>01/12/2021</td>
  </tr>
  <tr>
  <td>B3</td>
  <td>Buy</td>
  <td>01/05/2021</td>
  </tr>
  <tr>
  <td>B5</td>
  <td>Make</td>
  <td>01/04/2021</td>
  </tr>
  <tr>
  <td>C7</td>
  <td>Buy</td>
  <td>12/29/2020</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Thank you</p>