Problem with MySQL join query

Question

I just cant seem to get my head around this problem, so thought I would ask it here. The system I'm making is a system where farmers can claim subsidy for the crops / animals. Each farmer is allocated to a specific region. What I need to do is to get the total claims made by each region. Here's my tables: enter image description here

So what I need to do again is to take the sum of total from the claims table but group that by region. I already know how to do it for one specific region, but I would like to select all the regions in one query.

Thanks for your help, much appreciated!

DRapp · Accepted Answer · 2011-02-28 12:08:46Z

2

select 
      farmer.region_id,
      sum( claims.total ) TotalClaims
   from 
      claims
         join farmer
           on claims.farmer_id = farmer.id
         join regions
           on farmer.region_id = regions.id
   group by
      farmer.region_id

answered Feb 28, 2011 at 12:08

DRapp

48.3k13 gold badges80 silver badges149 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Problem with MySQL join query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related