title: Database join where
body: <p>Database</p>
  <p>Users</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">id</th>
  <th>lastname</th>
  <th>firstname</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">1</td>
  <td>Sardor</td>
  <td>Sattarov</td>
  </tr>
  <tr>
  <td style="text-align: center;">2</td>
  <td>Nurmuhammad</td>
  <td>To’xtayev</td>
  </tr>
  <tr>
  <td style="text-align: center;">3</td>
  <td>Jasur</td>
  <td>Sattarov</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Group_items</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">id</th>
  <th style="text-align: center;">student_id</th>
  <th style="text-align: center;">group_id</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">55</td>
  </tr>
  <tr>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;">55</td>
  </tr>
  <tr>
  <td style="text-align: center;">3</td>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;">11</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Return
  <strong>example 1</strong></p>
  <p><strong>condition</strong></p>
  <p><code>users.id == group_items.student_id</code> do not publish a table that satisfies this desire  <code>group_items.id == 55</code></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">id</th>
  <th>lastname</th>
  <th>firstname</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">3</td>
  <td>Jasur</td>
  <td>Sattarov</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><strong>example 2</strong></p>
  <p><strong>condition</strong></p>
  <p><code>users.id == group_items.student_id</code> do not publish a table that satisfies this desire  <code>group_items.id == 11</code></p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">id</th>
  <th>lastname</th>
  <th>firstname</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">1</td>
  <td>Sardor</td>
  <td>Sattarov</td>
  </tr>
  <tr>
  <td style="text-align: center;">3</td>
  <td>Jasur</td>
  <td>Sattarov</td>
  </tr>
  </tbody>
  </table>
  </div>