[font="Verdana"]
...I also need to show Skill_Groups that do not have any Jobs_Created_Last_7_Days...
Select category, count(dbjobskillgrp), count(dbjobstatus)
From {Table}
Where (dbjobcreatedDate Between {start date} And {end date} Or dbjobcreatedDate Is Null)
Group By category
confirm on this.
Mahesh
[/font]
MH-09-AM-8694