Having a little trouble with this question:
Using the two tables below, create a subquery or join statement that shows the player, Team, and No in the Player\_PROFILE table for all players coached by Fisher. 

![enter image description here](https://i.stack.imgur.com/io7VM.png)

I came up with the following SQL code but I'm not sure how to finish it or if its even right:

```
SELECT PLAYER_PROFILE.Player, PLAYER_PROFILE.Team,
PLAYER_PROFILE.No
FROM PLAYER_PROFILE
INNER JOIN PLAYER_DETAIL
ON......

```