>Sorry. It gives me the error: "Cannot GROUP by aggregate field"
>
>I appreciate the effort though. :)
Kevin,
It should be group by 2. You need to group by cKeyID. Isn't it obvious? You should be able to find it out by yourself!
Once again, try it and you'll see, that this is the simplest way to achieve your requirement!
If it's not broken, fix it until it is.
My Blog