title: Appending data from different tables - mysql
body: <p>I have the following tables <code>Job description</code> and <code>Candidate</code>.<br>
  Each job description can be related to n candidates. The candidates are obtained from different sources(a, b, c d) - <code>candidate.source</code>. </p>
  
  <p>I want a single query to list me the JD ids, with count of candidates for each source for each JD, as shown below:</p>
  
  <pre><code>JD id | candidate name | count of candidates - source a | count of candidates - source b | count of candidates - source | c..............
  </code></pre>