http://www.perlmonks.org?node_id=799140


in reply to Re: DBI MySQL Join Question
in thread DBI MySQL Join Question

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.