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

Angler Profile

Craig Belbeck

Hometown

Eagan, MN

Rookie Year

2005

Sportsmen Accolades

Sportsmen Tournament Results

2 tournaments

Date	Location	Place	Caught	Net Weight	Big Bass	Total Points
2020-07-19	Maple	12	4	8.27	3.37	8
2020-05-17	Minnetonka	10	0	0.00	0.00	6
Totals			4	8.27		14
Averages			2.00	4.14		7.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