I am trying to retrieve Lifetime batting stats from a baseball database... for each player, I want total homeruns and total atbats (from the batting table), as well as first and last names from another table (people table). How to accomplish this using SQL? (Please give examples). How can you incorporate a self join with an inner join in the same query?
Batting Table People Table
I’m a newbie, and quite frustrated with all the things I’ve tried, with no (or incorrect) results.
(Batting table only has single season records)… playerid in BOTH tables
Thanks in advance
Perplexed in Pittsburgh