CREATE VIEW Registrations AS (

  SELECT A.code, A.studentID, B.name
  FROM (
    SELECT code, studentID FROM StudentsOnWaitingList
    UNION
    SELECT code, studentID FROM StudentsRegisteredAtCourses
  ) A, Students B
  WHERE B.studentID IN A.studentID
);