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

Angler Profile

Zach Greenhouse

Hometown

Bloomington, MN

Rookie Year

2021

Sportsmen Accolades

Sportsmen Tournament Results

3 tournaments

Date Location Place Caught Net
Weight
Big Bass Total
Points
2021-09-19Farm Island1300.000.002
2021-07-11Mississippi River Pool 4/51400.000.001
2021-05-16Tetonka1500.000.002
Totals 0 0 5
Averages 0.00 0.00 1.67
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