select distinct student.stuId, student.fname, lname, semester from student, enroll, class where courseId = 2000 and enroll.classId = class.classId and enroll.stuId = Student.stuId;