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

Angler Profile

Paul Becka

Hometown

Bloomington, MN

Rookie Year

1989

Sportsmen Accolades

Sportsmen Tournament Results

8 tournaments

Date	Location	Place	Caught	Net Weight	Big Bass	Total Points
2021-08-22	German	3	5	10.11	3.40	13
2021-05-16	Tetonka	9	3	7.97	3.50	8
2020-10-11	O'Dowd	3	5	7.82	1.69	13
2020-09-20	Platte-Sullivan	9	4	6.27	2.56	6
2020-08-16	Green (Chisago)	13	1	1.30	1.30	5
2020-07-19	Maple	3	5	14.01	3.10	17
2020-06-21	Green (Spicer)	6	5	9.52	2.20	9
2020-05-17	Minnetonka	3	5	12.38	3.41	16
Totals			33	69.38		87
Averages			4.13	8.67		10.88

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