A EE Pro helped me out creating a functional two table query. I need to a use one field from a third table
the table is called NFLPassPlayInfo and the field is called season which would be the year. Just curious I just need the year to match playerid once not sixteen times. Cause in NFLPassPlayInfo a Playerid will come up at least 16 times cause of sixteen games in Nfl and if the team makes it into the playoffs even more. But maybe this is non issue I'm just wondering I got this for the SQL Statement If this sounds confusing let me know.Just need NFLPassPlayInfo and the column is called season just need it to match playerID tHANKS ee
sql = "Select FirstName,LastName,np.PlayerID,TeamID,Seasontype,Conference,Att,Comp,Yards,Long,TD,Inter,Sacks,SKYds,Rating FROM NflPlayers np"
sql += " join NFLPlayersPass npp on np.PlayerID = npp.PlayerID"
sql += " WHERE np.PlayerID= @PlayerID"