use test1;
CREATE VIEW resulet1
AS
SELECT stu.StudentNo,stu.StudentName from grade g,result r,student stu,`subject` sub
where g.GradeId=stu.GradeId AND stu.StudentNo=r.StudentNo
AND r.SubjectId=sub.SubjectId AND g.GradeId=sub.GradeId;
SELECT * from resulet1;
CREATE VIEW resulet1
AS
SELECT stu.StudentNo,stu.StudentName from grade g,result r,student stu,`subject` sub
where g.GradeId=stu.GradeId AND stu.StudentNo=r.StudentNo
AND r.SubjectId=sub.SubjectId AND g.GradeId=sub.GradeId;
SELECT * from resulet1;