USE lab07;

SELECT student.FirstName, professor.ProfessorName, student.StudentProgram, professor.ProfessorProgram
	FROM student
	RIGHT JOIN professor
    ON student.StudentProgram = professor.ProfessorProgram;

# Fields are null when a professor has no students in their program