You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'As BROKEHOA,  As ShotHOA FROM MV128881 LEFT JOIN skeet_awards ON MV128881.AWARD1' at line 1: SELECT MV128881.FNAME, MV128881.LNAME, MV128881.CITY, MV128881.STATE, MV128881.CLASSHOA,  skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order,  As BROKEHOA,  As ShotHOA FROM MV128881 LEFT JOIN skeet_awards ON MV128881.AWARD1HOA = skeet_awards.award_id_pk WHERE ((MV128881.BROKE12 + MV128881.BROKE20 + MV128881.BROKE28 + MV128881.BROKE410 > 0)) ORDER By BROKEHOA DESC