title: Sql Join Group by count
body: <p>This query written based on transaction table   </p>
  
  <pre><code>SELECT Ecode,COUNT(*) AS recvd 
  FROM Transaction_tbl 
  WHERE Locid=5 AND dtime BETWEEN '5/1/2013 00:00:00' AND '6/10/2013 23:59:59' 
  GROUP BY Ecode 
  ORDER BY Ecode DESC 
  </code></pre>
  
  <p>while executing this query i am getting out put like this</p>
  
  <pre><code>Ecode        recvd
  E003           24
  E001            2
  </code></pre>
  
  <p>I have One more table like Employee master ,there corresponding Employee name is save,,how i can join this table to Employee master table</p>
  
  <p>I want to get out put lik this</p>
  
  <pre><code>Ecode Ename Recvd
  E003   jas   24
  E001   deepu  14
  </code></pre>