20 - 20 Teams
Select teams.id, teams.team, teams.SponsorTelephone, players.fname, players.lname, players.telephone, Captain from teams, TeamSeason, PlayerSeason, players where teams.id = TeamSeason.TeamId and TeamSeason.season = and PlayerSeason.TeamId = TeamSeason.TeamId and PlayerSeason.Season = and PlayerSeason.Captain <> 0 and players.id = PlayerSeason.PlayerId order by team