关闭。这个问题需要细节或清晰。它目前不接受答案。
**想改进这个问题吗？**通过编辑这个帖子来添加细节并澄清问题。

两年前关门了。
改进这个问题
当我通过mysqlworkbench提交到mysql 5.7社区和mysql 8社区时，这个查询运行得很好。
我的语法来自https://github.com/antlr/grammars-v4/tree/master/mysql.
问题是：

SELECT
    `hr`.`employee`.`FirstName` AS `EmployeeFirstName`
    , `hr`.`employee`.`LastName` AS `EmployeeLastName`
    , `product`.`product`.`Description` AS `ProductDescription`
    , `product`.`unit`.`Unit` AS `Unit`
    , `product`.`product`.`SKU` AS `SKU`
    , `sales`.`transactiondetail`.`Qty` AS `Qty`
    , `product`.`product`.`UnitCost` AS `UnitCost`
    , `product`.`product`.`UnitPrice` AS `UnitPrice`
    , `product`.`manufacturer`.`Manufacturer` AS `Manufacturer`
    , `sales`.`transaction`.`EmployeeNumber` AS `EmployeeNumber`
    , `sales`.`transaction`.`LoyaltyNumber` AS `LoyaltyNumber`
    , `sales`.`transaction`.`StoreNumber` AS `StoreNumber`
    , `store`.`store`.`ZipCode` AS `ZipCode`
    , CAST(
        `sales`.`transaction`.`DateTimeOfTransaction` AS DATE
    ) AS `DateOfTransaction`
    , CAST(
        `sales`.`transaction`.`DateTimeOfTransaction` AS TIME
    ) AS `TimeOfTransaction`
    , CAST(
        CAST(
            `sales`.`transaction`.`DateTimeOfTransaction` AS DATE
        ) AS CHAR CHARSET utf8
    ) AS `DateOfTransactionString`
    , CAST(
        CAST(
            `sales`.`transaction`.`DateTimeOfTransaction` AS TIME
        ) AS CHAR CHARSET utf8
    ) AS `TimeOfTransactionString`
    , WEEKDAY(
        `sales`.`transaction`.`DateTimeOfTransaction`
    ) AS `WeekdayOfTransaction`
    , MONTH(
        `sales`.`transaction`.`DateTimeOfTransaction`
    ) AS `MonthOfTransaction`
    , YEAR(
        `sales`.`transaction`.`DateTimeOfTransaction`
    ) AS `YearOfTransaction`
    , DAYNAME(
        `sales`.`transaction`.`DateTimeOfTransaction`
    ) AS `WeekdayNameOfTransaction`
    , MONTHNAME(
        `sales`.`transaction`.`DateTimeOfTransaction`
    ) AS `MonthNameOfTransaction`
    , `sales`.`transactiondetail`.`TotalPrice` AS `TotalPrice`
FROM
    (
        (
            (
                (
                    (
                        (
                            `sales`.`transaction`
                            JOIN `sales`.`transactiondetail`
                                ON (
                                    (
                                        `sales`.`transaction`.`TransactionID` = `sales`.`transactiondetail`.`TransactionID`
                                    )
                                )
                        )
                        JOIN `hr`.`employee`
                            ON (
                                (
                                    `hr`.`employee`.`EmployeeNumber` = `sales`.`transaction`.`EmployeeNumber`
                                )
                            )
                    )
                    JOIN `product`.`product`
                        ON (
                            (
                                `product`.`product`.`SKU` = `sales`.`transactiondetail`.`SKU`
                            )
                        )
                )
                JOIN `product`.`unit`
                    ON (
                        (
                            `product`.`product`.`UnitID` = `product`.`unit`.`UnitID`
                        )
                    )
            )
            JOIN `store`.`store`
                ON (
                    (
                        `store`.`store`.`StoreNumber` = `sales`.`transaction`.`StoreNumber`
                    )
                )
        )
        JOIN `product`.`manufacturer`
            ON (
                (
                    `product`.`product`.`ManufacturerID` = `product`.`manufacturer`.`ManufacturerID`
                )
            )
    )

以下是antlr4引发的错误：
第1行：874“选择”输入没有可行的替代方案 hr . employee . FirstName 作为 EmployeeFirstName , hr . employee . LastName 作为 EmployeeLastName , product . product . Description 作为 ProductDescription , product . unit . Unit 作为 Unit , product . product . SKU 作为 SKU , sales . transactiondetail . Qty 作为 Qty , product . product . UnitCost 作为 UnitCost , product . product . UnitPrice 作为 UnitPrice , product . manufacturer . Manufacturer 作为 Manufacturer , sales . transaction . EmployeeNumber 作为 EmployeeNumber , sales . transaction . LoyaltyNumber 作为 LoyaltyNumber , sales . transaction . StoreNumber 作为 StoreNumber , store . store . ZipCode 作为 ZipCode ，铸造( sales . transaction . DateTimeOfTransaction 日期） DateOfTransaction ，铸造( sales . transaction . DateTimeOfTransaction 作为时间）作为 TimeOfTransaction ，铸造( sales . transaction . DateTimeOfTransaction 作为日期）作为字符集'