grouping counted data by column name <p>I have following table:</p> <ol> <li>QuranMaster</li> </ol> <p><img src="https://i.stack.imgur.com/57t1l.png" alt="enter image description here"></p> <p>2.QuranPrayed</p> <p><img src="https://i.stack.imgur.com/9Hk0Y.png" alt="enter image description here"></p> <p>I just wanted to have all the siparas and there count as result.</p> <p>Means expected result is as follows:</p> <pre><code>Sipara1 3 Sipara2 2 .. .. .. </code></pre> <p>Sipara1 is 3 because it has arrived 3 times in QuranPrayed.</p> <p>I made following query:</p> <pre><code>select qm.sipara,COUNT(qp.Sipara) from QuranMaster qm,QuranPrayed qp where qp.sipara=qm.sipara group by qm.sipara </code></pre> <p>This query works perfectly right when QuranPrayed has values.</p> <p>But when QuaranPrayed has no values, it does not shows me result.</p> <p>My expectation is:</p> <pre><code>Sipara1 0 Sipara2 0 .. .. .. </code></pre> <p>Please help me.</p>