Mysql 创建查询视图

CREATE
    /*[ALGORITHM = {UNDEFINED | MERGE | TEMPTABLE}]
    [DEFINER = { user | CURRENT_USER }]
    [SQL SECURITY { DEFINER | INVOKER }]*/
    VIEW `sjz2zz`.`vGls` 
    AS
(SELECT Gls.*,Catalog.`CatName` FROM Gls,Catalog WHERE Gls.`CatID`=Catalog.`CatID` ORDER BY gls.`InfoID` ASC);