SELECT *
FROM dbo.Student S
WHERE NOT EXISTS(SELECT 1 FROM dbo.Attendance
                 WHERE PerfectAttendance = 'N'
                 AND ID = S.ID);