USE lab07;

SELECT *
	FROM student
	LEFT JOIN professor
    ON student.StudentProgram = professor.ProfessorProgram;

# Fields are null when a student has no professor that matches their program