title: Complex select statment using Mysql
body: <p>I dont't now how to explain but i have two table in my database.</p>
  <ul>
  <li>tab 1: service</li>
  <li>tab 2: department</li>
  </ul>
  <p>service table:</p>
  <pre><code>idService
  serviceName
  department_ID
  is_deleted
  </code></pre>
  <p>department table:</p>
  <pre><code>departmentId
  departmenetName
  is_deleted
  </code></pre>
  <p>I want select all services with the departement name but with departement also if there is no service assigned to it.
  if there is no service assigned to a departement then the flelds will be shown but i must have null or equivalent in idService field.
  The result would be like this :</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>serviceID</th>
  <th>serviceName</th>
  <th>departmentId</th>
  <th>departmenetName</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>1</td>
  <td>IT</td>
  <td>2</td>
  <td>SI</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>2</td>
  <td>Maintenance</td>
  <td>6</td>
  <td>Mechanical</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>3</td>
  <td>Maintenance</td>
  <td>6</td>
  <td>Mechanical</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>4</td>
  <td>Opt Manager</td>
  <td>7</td>
  <td>Finance</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>5</td>
  <td>Instrument</td>
  <td>5</td>
  <td>Electric</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>NULL</td>
  <td>NULL</td>
  <td>1</td>
  <td>Civil</td>
  </tr>
  <tr>
  <td></td>
  <td></td>
  <td></td>
  <td></td>
  </tr>
  <tr>
  <td>8</td>
  <td>Agro</td>
  <td>NULL</td>
  <td>NULL</td>
  </tr>
  <tr>
  <td>_________</td>
  <td>___________</td>
  <td>____________</td>
  <td>_______________</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I have tried all kind of join options but I couldn't find the logic behind.
  I use Mysql as DB
  Any idea please ? Thank you.</p>