I need to create a query that calculates the number of years each player played for each of his teams. It is a baseball database, it has 3 tables, PLAYERS, STATS and TEAMS.

PLAYERS = Player IDr, first name, last name. STATS= player ID, year, team, hr , ab. TEAMS = city, ncknmae, league. I am doing this in MS Access.