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);
/*[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);