title: Query to get specific value between two table
body: <p>I have two table which contains two different primary key, lets call them, <strong>table1</strong> and <strong>table2</strong>.</p>
  <p>The tables may have the same number of columns.</p>
  <p>Table1:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>NOM</th>
  <th>CODE</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>AAA</td>
  <td>661YYYDD</td>
  </tr>
  <tr>
  <td>2</td>
  <td>BBB</td>
  <td>YYYD661</td>
  </tr>
  <tr>
  <td>3</td>
  <td>CCC</td>
  <td>YD661</td>
  </tr>
  <tr>
  <td>4</td>
  <td>DDD</td>
  <td>P5500Z</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Table 2:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>KEYCODE</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>661</td>
  </tr>
  <tr>
  <td>2</td>
  <td>55</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to be able to get by KEYCODE:
  ALL record in table1 which contain 661 or 55. For example when I select by 661 I get only the first 3 rows from tables1.</p>