select concat('Cost range is ', min(cost), '-', max(cost)) from mail_cost mc join mail_areas ma on mc.zone = ma.zone where ma.area between 1 and 10 and mc.weight = 12; #### zip area 001 2 002 2 003 2 005 3 012 6 [...] #### weight area cost 1 2 3.17 2 2 3.87 3 2 4.51 4 2 5.22 [...] 199 2 96.01 200 2 96.29 1 3 4.02 2 3 4.15 [...] #### $areas = ( '001' => 2, '002' => 2, '003' => 2, [...] );