视图

CREATE
    VIEW `test`.`Student` (Sno, Sname, Sage, Ssex, Sdept)
    AS
(SELECT sx.`Sno`,sx.`Sname`,sx.`Sage`,sy.`Ssex`,sy.`Sdept` FROM sx,sy WHERE sx.`Sno`=sy.`Sno`);