Here's the career totals of Henry Riggs, a guy who is basically Hank Aaron in my league, with the SQL I used to bring him back:
Code:
year team g ab r h 2B 3B hr rbi bb ibb k hpb sh sf sb cs gdp ba obp slg
1954 ATL 70 243 23 66 10 1 4 29 21 2 28 1 0 4 1 0 6 0.272 0.327 0.370
1955 ATL 84 288 31 83 14 1 13 48 23 1 36 2 0 6 0 0 4 0.288 0.339 0.479
1956 ATL 125 454 70 142 21 4 20 64 58 2 32 0 0 4 1 0 13 0.313 0.388 0.509
1957 ATL 152 552 99 182 38 1 23 79 65 4 30 0 0 7 0 0 14 0.330 0.396 0.527
1958 ATL 151 570 98 192 29 2 27 94 77 3 42 0 0 5 0 0 10 0.337 0.413 0.537
1959 ATL 153 577 96 188 28 1 37 96 72 6 47 2 0 4 0 0 11 0.326 0.399 0.570
1960 ATL 140 499 79 173 25 2 24 72 74 12 20 0 0 3 1 1 9 0.347 0.429 0.549
1961 ATL 142 527 94 175 33 1 28 88 76 7 23 1 0 6 2 2 20 0.332 0.413 0.558
1962 ATL 148 540 103 188 26 3 33 92 76 7 21 1 0 4 1 0 12 0.348 0.427 0.591
1963 ATL 113 423 87 144 20 0 37 104 57 2 15 1 0 6 0 2 15 0.340 0.415 0.650
1964 ATL 85 314 63 108 17 1 16 41 39 2 20 1 0 1 0 1 12 0.344 0.417 0.557
1965 ATL 159 558 108 177 17 1 45 116 95 9 29 1 0 5 1 1 16 0.317 0.414 0.593
1966 ATL 157 573 111 191 21 0 44 119 88 9 38 0 0 4 1 4 14 0.333 0.420 0.600
1967 ATL 127 465 79 136 17 0 29 72 69 12 40 1 0 5 0 0 12 0.292 0.381 0.516
1968 ATL 157 563 86 149 22 4 25 77 74 6 56 3 0 6 1 0 15 0.265 0.350 0.451
1969 ATL 112 397 78 131 15 0 32 79 79 7 26 1 0 5 0 0 8 0.330 0.438 0.610
Totals 2075 7543 1305 2425 353 22 437 1270 1043 91 503 15 0 75 9 11 191 0.321 0.401 0.548
Code:
set @player_id = 7620;
SELECT
bat.year,
tm.abbr as team,
bat.g,
bat.ab,
bat.r,
bat.h,
bat.d as 2B,
bat.t as 3B,
bat.hr,
bat.rbi,
bat.bb,
bat.ibb,
bat.k,
bat.hp as hpb,
bat.sh,
bat.sf,
bat.sb,
bat.cs,
bat.gdp,
round(bat.h / bat.ab, 3) as ba,
round((bat.h + bat.bb + bat.hp) / (bat.pa), 3) as obp,
round((bat.h + bat.d + 2 * bat.t + 3 * bat.hr) / ab, 3) as slg
FROM `modern-ish-baseball`.players_career_batting_stats bat
LEFT JOIN teams tm
on tm.team_id = bat.team_id
where player_id = @player_id
and tm.league_id = 100
and split_id = 1
UNION
SELECT
"Totals",
'',
sum(bat.g),
sum(bat.ab),
sum(bat.r),
sum(bat.h),
sum(bat.d),
sum(bat.t),
sum(bat.hr),
sum(bat.rbi),
sum(bat.bb),
sum(bat.ibb),
sum(bat.k),
sum(bat.hp),
sum(bat.sh),
sum(bat.sf),
sum(bat.sb),
sum(bat.cs),
sum(bat.gdp),
round((sum(bat.h)) / (sum(bat.ab)), 3),
round((sum(bat.h) + sum(bat.bb) + sum(bat.hp)) / (sum(bat.pa)), 3) as obp,
round((sum(bat.h) + sum(bat.d) + 2 * sum(bat.t) + 3 * sum(bat.hr)) / sum(bat.ab), 3) as slg
FROM `modern-ish-baseball`.players_career_batting_stats bat
LEFT JOIN teams tm
on tm.team_id = bat.team_id
where player_id = @player_id
and tm.league_id = 100
and split_id = 1
GROUP BY player_id
The player_id value might be a little tricky to get; you'd need to look the player in question up in the players table and find their ID. This should list teams in the chronological order they played in since it's just going by the order they were added to the DB.