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 ?

Tapan Patel · Answer

Yes. Sir. Is that working for you?

harry harish · Answer

yeah It worked :)

Tapan Patel · Answer

You are joining on wrong column. On course . [Course_ID] = student . [Student_ID] is the issue. Do something like this if student table contains the foreign key named course_id. On course . [Course_ID] = student . [Course_ID] this join won't return anything and hence you will not find the row with John Doe. Please mark it as an answer if it addresses the issue.

Gareth Bradley · Answer

Also i wouldn't check strings like that i would make use of LIKE keyword: WHERE STUDENT.[ NAME ] LIKE '%johndoe%'

harry harish · Answer

Hi Tapan I had asked couple of C#(VB.NET) questions yesterday I believe the page is no longer active. Can you please help me out with those questions please ? 1. Please review the following vb.net code and answer the corresponding questions. Public Function ParseClassesOfService( ByVal str As String ) As List ( Of ClassOfService ) Dim classList As New List ( Of ClassOfService ) Dim serviceClass As ClassOfService For Each text As String In str.Split( CChar (   )) serviceClass = New ClassOfService serviceClass.Code = text.Substring(0 1) classList.Add(serviceClass) Next Return ClassList End Function A. How many characters is the service class code according to this function? What is this function doing? Thanks

harry harish · Answer

Thank you Tapan so the current query would be :- Select * From [Course] course with ( nolock ) Join [Student] student with ( nolock ) On course . [Course_ID] = student . [ Course_ID ] Where student . [Name] = 'John Doe' correct ?