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 'Mickey' AND LastName LIKE 'Goetting' ORDER BY TOCSchedule.TOCScheduleID
tourney count= Mickey Goetting Angler Profile | Sportsmen Bassmasters

Angler Profile

Mickey Goetting

Hometown

Shakopee, MN

Rookie Year

2000

Sportsmen Accolades

Sportsmen Tournament Results

2 tournaments

Date	Location	Place	Caught	Net Weight	Big Bass	Total Points
2020-10-11	O'Dowd	11	2	4.26	2.77	5
2020-08-16	Green (Chisago)	11	1	3.69	3.69	8
Totals			3	7.95		13
Averages			1.50	3.98		6.50

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