A shot in the dark...
isn't the GROUP BY command lumping all the records together that have the same enhancement_id? If that's the case, then all the results are merged into that one record being returned... do you mean to have ORDER BY?
EDIT:
or maybe you need to be more specific on *which* enhancement_id you want to group by?
__________________
Greetings and salutations.
Last edited by Moskie; 05-17-2004 at 02:52 AM..
|