title: SQL query for two table relation
body: <p>I have two tables like below;</p>
  <p><a href="https://i.stack.imgur.com/mygeM.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mygeM.jpg" alt="enter image description here" /></a></p>
  <p>and I want the output is something like below;</p>
  <p><a href="https://i.stack.imgur.com/eh15g.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/eh15g.jpg" alt="enter image description here" /></a></p>
  <p>I used the SQL query code below</p>
  <p><a href="https://i.stack.imgur.com/SuLxu.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SuLxu.jpg" alt="enter image description here" /></a></p>
  <pre><code>select table2.StatusName as StatusName, count(table1.Status) as NoOfStatus from testingdb.table1, testingdb.table2 where table1.Status=table2.Status group by table1.Status; 
  </code></pre>
  <p>Anyone can help me in SQL, how to create SQL code to get the result as output.
  Really appreciate..</p>
  <p>Thanks you very much.</p>