Select S.StudentName , S.StudentId from StudentsPerYear as SLeft outer joinSTUDENTS_COURSES as COn S.StudentId = C.StudentIdAnd S.year = C.yearWhereAnd S.year = 2006C.StudentId is null