If I understand you correctly then all the players in the table 'Fan Dual Players' are the players available today.
Just join the two tables together using the 'Player Name' field, and you will be able to run a report on the 'Fan Dual Players' table, and show the link from the associated 'NBA Players' record.
Please see the attached, does this help?
Thank you. I feel silly. I figured it out this morning...Now I have a scripting challenge that is making me crazy!