SELECT l.areasymbol AS Area_symbol, l.areaname AS Area_name, musym AS Map_unit_symbol, muname AS Map_unit_name,
m.mukey AS MUKEY, cropname AS Crop, nonirryield_l AS Low_yield, nonirryield_r AS RV_yield, nonirryield_h AS High_yield, yldunits AS Units
FROM legend AS l
INNER JOIN mapunit AS m ON m.lkey = l.lkey AND areasymbol LIKE
'OH%'
INNER JOIN component AS c ON c.mukey = m.mukey AND majcompflag LIKE 'Yes' AND nirrcapcl IN
('5', '6','7','8')
LEFT OUTER JOIN mucropyld AS mc ON mc.mukey = m.mukey
WHERE
(cropname LIKE 'corn' OR cropname LIKE 'soybeans' OR cropname LIKE '%wheat%')
ORDER BY areasymbol, musym