选择不在另一个表中的行，SQL Server查询

SELECt SubjectID, DepartmentID, SubjectName, SubjectDescription, SubjectShortCodeFROM BS_Subject WHERe NOT EXISTS (SELECt SubjectToClassID FROM BS_SubjectToClass WHERe BS_Subject.SubjectID = BS_SubjectToClass.SubjectIDAND BS_SubjectToClass.ClassID =2)