title: Oracle: fetch value of columns based on another table column
body: <p>I have two tables, one of them is a main table and the other is the decode. The decode has 142 rows and 2 columns. Cause of death code and description. The main table has person information and the reason of death and secondary reason of death.</p>
  <p><strong>Decode table</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>code</th>
  <th>description</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>infection</td>
  </tr>
  <tr>
  <td>2</td>
  <td>covid</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><strong>main table</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">client</th>
  <th style="text-align: center;">reason_1</th>
  <th style="text-align: right;">reason_2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: right;">null</td>
  </tr>
  <tr>
  <td style="text-align: left;">02</td>
  <td style="text-align: center;">2</td>
  <td style="text-align: right;">1</td>
  </tr>
  <tr>
  <td style="text-align: left;">03</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: right;">2</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><strong>Expected table</strong></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: left;">client</th>
  <th style="text-align: center;">reason_1</th>
  <th style="text-align: right;">reason_2</th>
  <th style="text-align: center;">reason_1_desc</th>
  <th style="text-align: right;">reason_2_desc</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: left;">01</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: right;">null</td>
  <td style="text-align: center;">infection</td>
  <td style="text-align: right;">null</td>
  </tr>
  <tr>
  <td style="text-align: left;">02</td>
  <td style="text-align: center;">2</td>
  <td style="text-align: right;">1</td>
  <td style="text-align: center;">covid</td>
  <td style="text-align: right;">infection</td>
  </tr>
  <tr>
  <td style="text-align: left;">03</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: right;">2</td>
  <td style="text-align: center;">infection</td>
  <td style="text-align: right;">covid</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>How can I get this output without typing in all the values from decode table and using decode function or subquery factoring?</p>