Shoot Selection 
Select Single Shooter 
Doubles
All Scores 
Event 1
All Scores 
Event 2
All Scores 
Event 3
All Scores 
Event 4
All Scores 
HOA
All Scores 
HAA
All Scores 
  Michigan Skeet
Results
 
: ( SELECT MV116896.FNAME, MV116896.LNAME, MV116896.CITY, MV116896.STATE, MV116896.CLASSHAA, MV116896.AWARD1HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV116896 LEFT JOIN skeet_awards ON MV116896.AWARD1HAA = skeet_awards.award_id_pk WHERE MV116896.AWARD1HAA >= 1 AND MV116896.ENTRY = 2 ) UNION ALL ( SELECT MV116896.FNAME, MV116896.LNAME, MV116896.CITY, MV116896.STATE, MV116896.CLASSHAA, MV116896.AWARD2HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV116896 LEFT JOIN skeet_awards ON MV116896.AWARD2HAA = skeet_awards.award_id_pk WHERE MV116896.AWARD2HAA >= 1 AND MV116896.ENTRY = 2 ) UNION ALL ( SELECT MV116896.FNAME, MV116896.LNAME, MV116896.CITY, MV116896.STATE, MV116896.CLASSHAA, MV116896.AWARD3HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV116896 LEFT JOIN skeet_awards ON MV116896.AWARD3HAA = skeet_awards.award_id_pk WHERE MV116896.AWARD3HAA >= 1 AND MV116896.ENTRY = 2 ) UNION ALL ( SELECT MV116896.FNAME, MV116896.LNAME, MV116896.CITY, MV116896.STATE, MV116896.CLASSHAA, MV116896.AWARD4HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV116896 LEFT JOIN skeet_awards ON MV116896.AWARD4HAA = skeet_awards.award_id_pk WHERE MV116896.AWARD4HAA >= 1 AND MV116896.ENTRY = 2 ) UNION ALL ( SELECT MV116896.FNAME, MV116896.LNAME, MV116896.CITY, MV116896.STATE, MV116896.CLASSHAA, MV116896.AWARD5HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV116896 LEFT JOIN skeet_awards ON MV116896.AWARD5HAA = skeet_awards.award_id_pk WHERE MV116896.AWARD5HAA >= 1 AND MV116896.ENTRY = 2 ) UNION ALL ( SELECT MV116896.FNAME, MV116896.LNAME, MV116896.CITY, MV116896.STATE, MV116896.CLASSHAA, MV116896.AWARD6HAA, skeet_awards.abbrrev AS award_disp, skeet_awards.sort_order, AS ShotHOA, As ShotHAA, As BROKEHOA, As BROKEHAA FROM MV116896 LEFT JOIN skeet_awards ON MV116896.AWARD6HAA = skeet_awards.award_id_pk WHERE MV116896.AWARD6HAA >= 1 AND MV116896.ENTRY = 2 ) ORDER By sort_order