Tilted Forum Project Discussion Community - View Single Post - [MySQL] My brain blew a fuse (multi-table select, joins)

Moskie · 05-17-2004, 02:47 AM

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?

05-17-2004, 02:47 AM	#2 (permalink)
Moskie Pure Chewing Satisfaction Location: can i use bbcode [i]here[/i]?	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..