SELECT * FROM student_course_registrations WHERE student_id NOT IN (SELECT student_id FROM student_course_attendance)
What are all info of students who registered courses but not attended courses?
SELECT * FROM student_course_registrations WHERE student_id NOT IN ( SELECT student_id FROM student_course_attendance )
select * from student_course_registrations where student_id not in ( select student_id from student_course_attendance )
What are all info of students who registered courses but not attended courses ?