title: Joining two tables on mysql
body: <p>I have two tables. </p>
  
  <p>First table  represented below includes the Count of dialled call hour wise by certain number</p>
  
  <pre><code>+-------------+---------------+-------+
  | Card_no     | Dialled_Count | Hour  |
  +-------------+---------------+-------+
  | 9913528756  |   9           |  10   |
  | 9913528756  |   2           |  11   |
  | 9913528756  |   10          |  23   |
  +-------------+---------------+-------+
  </code></pre>
  
  <p>And the other table represents the Count of message sent hourwise.</p>
  
  <pre><code>+-------------+---------------+-------+
  | Card_no     | Message_Count |  Hour |
  +-------------+---------------+-------+
  | 9913528756  |   5           |  6    |
  | 9913528756  |   10          |  10   |
  | 9913528756  |   12          |  17   |
  +-------------+---------------+-------+
  </code></pre>
  
  <p>I want to join these tables with the  expected final result as :</p>
  
  <pre><code>+-------------+---------------+-------+--------------+
  | Card_no     | Dialled_Count |  Hour | Message_count|
  +-------------+---------------+-------+--------------+
  | 9913528756  |   0           |  6    |   5          |
  | 9913528756  |   9           |  10   |   10         |
  | 9913528756  |   2           |  11   |   0          |
  | 9913528756  |   0           |  17   |   12         |
  | 9913528756  |   10          |  23   |   0          |
  +-------------+---------------+-------+--------------+
  </code></pre>
  
  <p>Any helps are appreciated</p>
  
  <p>Thanks in advance...</p>