View Single Post
Old 05-17-2004, 03:09 AM   #3 (permalink)
seretogis
Huggles, sir?
 
seretogis's Avatar
 
Location: Seattle
Quote:
Originally posted by Moskie
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?
Yeah, I think the GROUP BY usage is definitely a factor in the problem, but I'm not sure how else it could be used, or what it should be replaced with. If I eliminate the GROUP BY clause completely, my query returns, literally, 1500 results -- every possible combination of server/origin/enhancement effect. If I change the enhancement_id to e.enhancement_id or fj or oj, I get the same result as I get with just "GROUP BY enhancement_id". Thanks for the response.
__________________
seretogis - sieg heil
perfect little dream the kind that hurts the most, forgot how it feels well almost
no one to blame always the same, open my eyes wake up in flames
seretogis is offline  
 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54