Originally posted by ss659
You also missed the COUNT statement in your first post...you can only group when using aggregate functions such as min..max..etc.
Glad to hear you got it working though
Hey ss659.. .A small correction
It is not necessary that an aggregate function must be used when using the group by clause... The only thing that is required is that all the columns in the select clause must appear in the group by... however the column used in an aggregate function need not be in the group by