我正在处理的一个遗留应用程序有一个sql查询，它从一个表中选择几个属性。在这个 restaurant_chef_hats 表中，我可以运行如下查询： SELECT FirstName FROM restaurant_chef_hats; 一些查询后面有第二个参数 FROM ，但在几个 LEFT JOIN 行动开始了。
给出一个类似于。。。 SELECT FirstName FROM restaurant_chef_hats employees LEFT JOIN ON (~~ some criteria ~~ ) ……这件事的意义是什么 employees 参数？
编辑
进一步的上下文：这是在一个命令的上下文中，该命令基于现有表创建一个新的mysql数据库。这是完整的查询，表/列名已更改。在这个例子中，我的问题与这个词的目的有关 hatser 内 FROM loccodeofchats hatser .:

DROP TABLE IF EXISTS `restaurant_chef_hats`;
CREATE TABLE restaurant_chef_hats AS
    SELECT
        hatser.TakeoutID,
        hats_dish.TakeoutID as cooked_dish_id,
        member.RestabName As chef_title,
        prefix.PrefixCode as Prefix,
        suffix.SuffixCode as Suffix,
        hatser.Title,
        roles.LUTOrder AS Rank,
        address.TypeID,
        hatser.AppetizerID as SouschefID,
        hatser.AppetizerID_2 as SouschefID_2,
        hatser.AppetizerID_3 as SouschefID_3,
        roles.RoleDescShort as RoleDesc,
        roles2.RoleDescShort as RoleDesc_2,
        roles3.RoleDescShort as RoleDesc_3,
        dish.FirstName,
        dish.LastName,
        dish.MiddleName,
        dish.NickName,
        fork.ForkDesc,
        sweet.SweetDesc,
        register.RegisterDesc,
        address.P_Room,
        address.P_Building,
        address.P_Street,
        address.P_Street2,
        state.StateAbbr,
        address.P_City,
        address.P_ZipCode,
        dish.LastUpdated,
        hats_dish.BirthdayPartyID,
        party.PartyCode,
        party.PartyDesc,
        address_type.AddressTypeDesc,
        CONCAT('(', phone.AreaCode,') ', phone.Phone) as Telephone,
        CONCAT('(', fax.AreaCode,') ', fax.Phone) as Fax,
        stats.MaritalStatusDesc,
        dish.CreationPlace,
        dish.CreationYear,
        dish.CreationMonth,
        dish.CreationDate,
        dish.WineCouplingName,
        dish.Origin,
        dish.Family,
        CONCAT_WS(' ',hats_dish.FirstName,hats_dish.LastName) as officeOf
    FROM loccodeofchats hatser
        LEFT JOIN loccodeofc member ON (hatser.FoodRestabID=member.FoodCounterID AND member.SouschefID=47 AND member.StateID = 0)
        LEFT JOIN soups dish ON (hatser.TakeoutID=dish.TakeoutID)
        LEFT JOIN soups hats_dish ON (member.TakeoutID=hats_dish.TakeoutID)
        LEFT JOIN soupsaddresses address ON (hatser.TakeoutID=address.TakeoutID AND address.DisplayOrder=1)
        LEFT JOIN restaurantgeneralstates state ON (state.StateID=address.P_StateID)
        LEFT JOIN restaurantlegbirthdayparties party ON (hats_dish.BirthdayPartyID=party.FoodBirthdayPartyID)
        LEFT JOIN soupsphones phone ON (phone.TakeoutID=hatser.TakeoutID AND phone.TypeID=1)
        LEFT JOIN soupsphones fax ON (fax.TakeoutID=hatser.TakeoutID AND fax.TypeID=2)
        LEFT JOIN restaurantdesserts roles ON (hatser.AppetizerID=roles.AppetizerID)
        LEFT JOIN restaurantdesserts roles2 ON (hatser.AppetizerID_2=roles2.AppetizerID AND hatser.AppetizerID_2 IS NOT NULL)
        LEFT JOIN restaurantdesserts roles3 ON (hatser.AppetizerID_3=roles3.AppetizerID AND hatser.AppetizerID_3 IS NOT NULL)
        LEFT JOIN restaurantspoonsprefix prefix ON prefix.PrefixID=dish.PrefixID
        LEFT JOIN restaurantspoonssuffix suffix ON suffix.SuffixID=dish.SuffixID
        LEFT JOIN restaurantspoonsfork fork ON (fork.ForkID=dish.ForkID)
        LEFT JOIN restaurantspoonssweet sweet ON (sweet.SweetID=dish.SweetID)
        LEFT JOIN restaurantspoonsregister register ON (register.RegisterID=dish.RegisterID)
        LEFT JOIN restaurantspoonsmaritalstatus stats ON (stats.MaritalStatusID=dish.MaritalStatusID)
        LEFT JOIN restaurantroleaddresstypes address_type ON (address.TypeID = address_type.AddressTypeID)
    WHERE hats_dish.TakeoutID != 165208
    GROUP BY hatser.TakeoutID, hatser.FoodRestabID;

ALTER TABLE restaurant_chef_hats ADD pk_column INT AUTO_INCREMENT PRIMARY KEY;
ALTER TABLE restaurant_chef_hats ADD INDEX Updated_Index (LastUpdated);
ALTER TABLE restaurant_chef_hats ADD INDEX TakeoutID_Index (TakeoutID);
ALTER TABLE restaurant_chef_hats ADD INDEX Ordered_TakeoutID_Index (cooked_dish_id);