Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re^2: DBI MySQL Join Question

by Jazz (Curate)
on Oct 04, 2009 at 23:54 UTC ( #799140=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://799140]
help
Chatterbox?
[Corion]: Yay, vacation time now - one week off work (but a Perl workshop in the middle ;)) )
[talexb]: TStanley I just realized that I was in your area for a convention back in April. We were at the high school for the weekend, the one with the long driveway. Nice spot.
[TStanley]: I am heading to Arlington, Virginia next week, then I get to spend an entire week at home. Looking forward to that as I will have spent 7 weeks on the road by the end of next week
[talexb]: That's a long road trip. I haven't travelled for business in years.

How do I use this? | Other CB clients
Other Users?
Others surveying the Monastery: (7)
As of 2017-06-23 14:21 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    How many monitors do you use while coding?















    Results (548 votes). Check out past polls.