Forums - C# Corner

Forum guidelines
harry harish

harry harish

  • 1.5k
  • 18
  • 477

pls help me out with this SQL query

Sep 13 2016 2:42 PM

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 ?

Attachment: sql.rar

Answers (6)