mysql - Conditional Queries -

having little trouble question: using 2 tables below, create subquery or join statement shows player, team, , no in player_profile table players coached fisher.

i came following sql code i'm not sure how finish or if right:

select player_profile.player, player_profile.team, player_profile.no player_profile inner join player_detail on...... 

isnt - or missing in question

select player_profile.player, player_profile.team, player_profile.no player_profile inner join player_detail on player_profile.player=player_detail.player player_detail.coach = 'fisher';