Flying Duck: 20 - 20 Players
Select players.id, players.fname, players.lname, players.telephone, PlayerSeason.Captain from players, PlayerSeason where players.id = PlayerSeason.PlayerId and PlayerSeason.Season = and PlayerSeason.TeamId = 8 Order By lname, fname;