good chemistry is complicated, and a little bit messy -LW |
|
PerlMonks |
Re^2: DBI MySQL Join Questionby Jazz (Curate) |
on Oct 04, 2009 at 23:54 UTC ( [id://799140]=note: print w/replies, xml ) | Need Help?? |
When I add the GROUP BY and COUNT() clauses as you noted, I get only 2 out of 10 Image records. When I change the GROUP BY to Images.ImageID instead of imgThemes.ImageID, I get all Image returned (unduplicated), but only one result from imgThemes. I need all of the records from imgThemes which match the ImageID.
If you have time, please see the data structure I'm looking for in my reply to zwon above.
In Section
Seekers of Perl Wisdom
|
|