USE lab10;

DELIMITER //
CREATE PROCEDURE LeftStoredProcedure()
BEGIN
	SELECT *
		FROM professor
			LEFT JOIN student
			ON professor.ProfessorProgram = student.StudentProgram;
END //
DELIMITER ;