create view EXAM_RESULT_VIEW

as


select STUDENT_NAME, SURNAME, SUBJECT_NAME, EXAM_RESULT_POINTS, EXAM_RESULT
   from STUDENT
	left join RESULT on STUDENT.ID_STUDENT = RESULT.ID_STUDENT
	right join SUBJECTS  on  SUBJECTS.ID_SUBJECT = RESULT.ID_SUBJECT




/*

Pouziti:

	select * from EXAM_RESULT_VIEW


View se chová jako tabulka.

*/