Welcome Guest, Not a member yet? Register   Sign In
Stumped with complicated MySQL Query!
#2

[eluser]crumpet[/eluser]
No sql expert but perhaps try making the service_are_basins and service_area_counties right joins....
then use max(service_area_basins.percent) AS basins_percent and max(service_area_counties) AS counties_percent
in your select query


Messages In This Thread
Stumped with complicated MySQL Query! - by El Forum - 07-10-2008, 09:36 AM
Stumped with complicated MySQL Query! - by El Forum - 07-10-2008, 10:13 AM
Stumped with complicated MySQL Query! - by El Forum - 07-10-2008, 11:32 AM
Stumped with complicated MySQL Query! - by El Forum - 07-10-2008, 11:39 AM
Stumped with complicated MySQL Query! - by El Forum - 07-10-2008, 02:58 PM



Theme © iAndrew 2016 - Forum software by © MyBB