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)
