Something wrong with my query, what am I doing wrong?

There is something wrong with my query, what am I doing wrong?

select	mmatter, mdesc1, 
		tklast + ', ' + tkfirst + ' (' + tkinit + ')' as WA,
		sum(hwacur) as MTD_Billable_hours,
		sum(hwaytd) as YTD_Billable_hours
from df_dwtkmat , df_dwcontrol, matter, timekeep
where matter in (select	distinct  mmatter from timecard
					where ttk='02500'
					and tworkdt between getdate()-30 and getdate())
and rectype=4020
and defvalue=pe
and matter=mmatter
and watty=tkinit
group by mmatter, mdesc1, 
		tklast + ', ' + tkfirst + ' (' + tkinit + ')'
having sum(hwacur) <> 0 or
		sum(hwaytd)<> 0
order by 		mmatter, mdesc1, 
		tklast + ', ' + tkfirst + ' (' + tkinit + ')'

Select allOpen in new window