Hi,
I have a query written to fetch this details

SELECT FF.APPROVAL_LEVEL as APPLEVEL ,COUNT(CA.STATUS) as PROPOSALCASE,null as EXCEPTIONCASE
FROM SML_CA CA,SML_FP_FOLDER FF,SML_FP_FOLDER_DETAILS FFD
WHERE CA.STATUS in('APPROVED','DECLINED','RETURNED')
AND CA.REVIEW_BY_EXCEPTION is null
AND FF.APPROVAL_LEVEL is not null
AND FF.ID = FFD.FP_FOLDER_ID
AND FFD.FP_ID = CA.ID
GROUP BY FF.APPROVAL_LEVEL
UNION ALL
SELECT FF.APPROVAL_LEVEL as APPLEVEL,null as PROPOSALCASE,COUNT(CA.STATUS) as EXCEPTIONCASE
FROM SML_CA CA,SML_FP_FOLDER FF,SML_FP_FOLDER_DETAILS FFD
WHERE CA.STATUS in('APPROVED','DECLINED','RETURNED')
AND CA.REVIEW_BY_EXCEPTION ='Y'
AND FF.APPROVAL_LEVEL is not null
AND FF.ID = FFD.FP_FOLDER_ID
AND FFD.FP_ID = CA.ID
GROUP BY FF.APPROVAL_LEVEL
ORDER BY APPLEVEL DESC


the o/p of the above is
APPLEVEL
PROPOSALCASE
EXCEPTIONCASE
4
34

3
44

2
56

2

67
1
68

1

78





i want the o/p in this format



APPLEVEL
PROPOSALCASE
EXCEPTIONCASE
4
34

3
44

2
56
67
1
68
78






























Regards
Raj

the o/p of the above is


APPLEVEL
PROPOSALCASE
EXCEPTIONCASE
4
34

3
44

2
56

2

67
1
68

1

78





i want the o/p in this format





APPLEVEL
PROPOSALCASE
EXCEPTIONCASE
4
34

3
44

2
56
67
1
68
78

Did you try put all of them in only one select???

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========