Stumped with complicated MySQL Query!

[eluser]jleequeen[/eluser]
Wow, well that worked as far as getting the basin and county with the highest percentage. But by changing the joins, it is now only returning 103 rows instead of 106. The reason this would be, is because there are 3 water systems that have started a plan that is in draft..but they haven't gotten to the service area sections so they are not being included in the query. With the left joins all 106 are there. Basically I added the left joins back, but kept the max on the service area percents and removed the Order by statements, and I think it's working now. I'm going to double check to make sure, but thanks for steering me in the right direction. I'll let you know if it's working for sure.