>I was trying the group by clause in both the select statements
>Rajesh
The GROUP BY clause in each part of UNION Selects will group only the part where it is used. What you trying to do? Can you post some example data and desired result?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.