I Two tables (show in red)
I have something like below:
and inside hockeystats_teams
I have the below..
Now, if I want to show the list of player I do not want the team they are on to just show "thunder" I would like it to show "Tri-Town Thunder".
As far as the comment as I don't know the teams I am meaning that this may be used for other leagues
which have different teams and different team names so I cannot just hardcode an 'if' statement into my code. See what I'm saying now?