title: Join tables and Concatenate Multiple Rows Within Single Row
body: <p>Join multiple table and concatenate multiple rows into one for distinct department names.</p>
  <p>I was able to do it on table EmpDepartment but I need to join all table.
  Expected output like this.</p>
  <p>Need Query</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>EmpID</th>
  <th>EmpName</th>
  <th>DepartmentName</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>A</td>
  <td>q,w,e</td>
  </tr>
  <tr>
  <td>2</td>
  <td>B</td>
  <td>Null</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p><a href="https://i.stack.imgur.com/giHvm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/giHvm.png" alt="ER DIAGRAM" /></a></p>