代码之家 › 专栏 › 技术社区 › Black

SQL Server 2016虚拟表-语法“AS”不正确

sql-server

Black · 技术社区 · 7 年前

level 带柱 level_id 和 level_name

这不是一个真正的查询-我已经尽可能地简化了它以说明错误

SELECT
    LEVEL .level_id,
    LEVEL .level_name
FROM
    LEVEL,
    ((SELECT
          LEVEL_ID AS lev_sum_level_id
      FROM
          LEVEL
      GROUP BY
          level_id) AS lev_sum
     JOIN
         (SELECT
              LEVEL_ID AS lev_det_level_id
          FROM
              LEVEL
          GROUP BY
              level_id) AS lev_det ON (lev_sum_level_id = lev_det_level_id)
  ) AS totals

AS totals .

关键字“AS”附近的语法不正确

1 回复 | 直到 7 年前

SKLTFZ 7 年前

我认为您可以尝试添加一个select,以便完成语句的语法

请试一试

SELECT
T1.MiscID,
T2.lev_sum_level_id
FROM
Miscs AS T1,
(
    SELECT * FROM
    (
        SELECT
            MiscID AS lev_sum_level_id
        FROM
            Miscs
        GROUP BY
            MiscID
    ) AS lev_sum
    JOIN
    (
        SELECT
            MiscID AS lev_det_level_id
        FROM
            Miscs
        GROUP BY
            MiscID
    ) AS lev_det 
    ON( lev_sum_level_id = lev_det_level_id )
) AS T2

推荐文章