This query written based on transaction table 

```
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 

```

while executing this query i am getting out put like this

```
Ecode        recvd
E003           24
E001            2

```

I have One more table like Employee master ,there corresponding Employee name is save,,how i can join this table to Employee master table

I want to get out put lik this

```
Ecode Ename Recvd
E003   jas   24
E001   deepu  14

```