hi mufasa,
I am not getting the correct results when i use the above. but i did in a different way, i am getting the correct results. see the below query:
SELECT
A.CRITERIA_NAME,count(*),
A.DEPT ,
A.DIVISION ,
A.SECTION ,
A.SECTION_NAME
FROM CRITERIA A,DEPT_TABLE...