pls help me out with this SQL query

Question

1. IIf we had a student with the name “John Doe”, why the following SQL code is not returning all of the John’s courses? 

Select *

From [Course] course with (nolock)

Join [Student] student with (nolock)

On course.[Course_ID] = student.[Student_ID]

Where student.[Name] = 'John Doe'

can someone explain me the reason behind it , I need t make use of nolock for sure, Can someone fix the query ?