I have two Table one contains Student name and 2nd exam record Now i w

Manju Jd

Hi Developers I have two Table one contains Student name and 2nd exam record Now i want to select Student name which is not on exam record please help me

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar4y ago
Use NOT IN or use a LEFT JOIN+WHERE exam.id IS NULL
0
Sachin Singh4y ago
Let's say Student (StudentId,StudentName) ExamRecords (ExamId,StudentId,ExamStatus.....)
select StudentName from Student
where StudentId not in (select studentId from ExamRecords)
0