SELECT TournamentYear, TournamentLocation, Division, Day1Place, Day1Caught, Day1NetWeight, Day1BigBass, Day2Place, Day2Caught, Day2NetWeight, Day2BigBass, Day3Place, Day3Caught, Day3NetWeight, Day3BigBass, TotalPlace, TotalCaught, TotalNetWeight, TotalBigBass FROM TOCMemberResults INNER JOIN TOCSchedule ON TOCSchedule.TOCScheduleID = TOCMemberResults.TOCScheduleID FROM TOCMemberResults INNER JOIN TOCSchedule ON TOCSchedule.TOCScheduleID = TOCMemberResults.TOCScheduleID WHERE FirstName LIKE 'Chris' AND LastName LIKE 'Glaze' ORDER BY TOCSchedule.TOCScheduleID
tourney count= Chris Glaze Angler Profile | Sportsmen Bassmasters

Angler Profile

Chris Glaze

Hometown

St. Louis Park, MN

Rookie Year

2005

Sportsmen Accolades

Sportsmen Tournament Results

2 tournaments

Date	Location	Place	Caught	Net Weight	Big Bass	Total Points
2020-08-16	Green (Chisago)	17	0	0.00	0.00	3
2020-07-19	Maple	7	5	10.15	3.43	13
Totals			5	10.15		16
Averages			2.50	5.08		8.00

to do load rest of tourney results into database
to do break by Year

MN B.A.S.S. Nation TOC Results

			Day 1				Day 2				Day 3				Total
Date	Location	Division	Place	Caught	Net Weight	Big Bass	Place	Caught	Net Weight	Big Bass	Place	Caught	Net Weight	Big Bass	Place	Caught	Net Weight	Big Bass