TryingToLearn (5/3/2013)

---

I figured it out....Thank you,

I would like to return all the data for a single empnum, but this query is returnng data for ALL empnum's. any suggestion would be greatly appreciated.

select E.empnum, rtrim(C.lname) + ', ' + rtrim(C.fname) as Name,

rtrim(substring(C.dept,1,3)) as Office,

C.dept,

calldate,

duration_in_decimal,

io

from CALLS C INNER JOIN EMP E on C.empnum = E.empnum and C.empnum = 6396 where

(month(calldate) = case month('2012/11/30') when '1' then '12' else month('2012/11/30') - 1 end and

year(calldate) = case month('2012/11/30') when '1' then year('2012/11/30') - 1 else year('2012/11/30') end and duration_in_decimal > .0055555

and (len(phonenum) IN (7,10,11))) or (month(calldate) = case month('2012/11/30') when '1' then '12' else month('2012/11/30') - 1 end and

year(calldate) = case month('2012/11/30') when '1' then year('2012/11/30') - 1 else year('2012/11/30') end and io = 'I')

ORDER BY C.empnum;