i am new to sql i want to get some values from different tables and i have made my own logic like that
"SELECT course_name, course_id FROM tbl_course WHERE course_id = (SELECT course_id FROM tbl_enrollment WHERE student_id = '" + lbl_StudentID.Text + "')"
what could the correct sytax for this
the subquery returns more than one value that is
there are some course ids corresponding to student id in enrollment table
now i want to select course name and course id from course table which matches those course ids