当前位置: 代码迷 >> Sql Server >> Incorrect syntax near the keyword 'SELECT'.解决方法
  详细解决方案

Incorrect syntax near the keyword 'SELECT'.解决方法

热度:179   发布时间:2016-04-27 15:54:49.0
Incorrect syntax near the keyword 'SELECT'.
SELECT   t0.KS_ID   AS   [编号],   t0.KS_Name   AS   [姓名],   t1.Value   AS   [拟任岗位的匹配性],  
            t2.Value   AS   [综合分析能力],   t3.Value   AS   [计划、组织能力],  
            t4.Value   AS   [人际交往与协调能力],   t5.Value   AS   [应变能力],  
            t6.Value   AS   [语言表达能力],   t7.Value   AS   [气质与仪表]
FROM   (SELECT   DISTINCT   KS_ID,   KS_Name
                FROM   VIEW_KS_AvgScore)   t0,
                    (SELECT   KS_ID,   PF_Name,   Value
                  FROM   VIEW_KS_AvgScore
                  WHERE   PF_Name   =   '拟任岗位的匹配性 ')   t1,
                    (SELECT   KS_ID,   PF_Name,   Value
                  FROM   VIEW_KS_AvgScore
                  WHERE   PF_Name   =   '综合分析能力 ')   t2,
                    (SELECT   KS_ID,   PF_Name,   Value
                  FROM   VIEW_KS_AvgScore
                  WHERE   PF_Name   =   '计划、组织能力 ')   t3,
                    (SELECT   KS_ID,   PF_Name,   Value
                  FROM   VIEW_KS_AvgScore
                  WHERE   PF_Name   =   '人际交往与协调能力 ')   t4
                    (SELECT   KS_ID,   PF_Name,   Value
                  FROM   VIEW_KS_AvgScore
                  WHERE   PF_Name   =   '应变能力 ')   t5
                    (SELECT   KS_ID,   PF_Name,   Value
                  FROM   VIEW_KS_AvgScore
                  WHERE   PF_Name   =   '语言表达能力 ')   t6
                    (SELECT   KS_ID,   PF_Name,   Value
                  FROM   VIEW_KS_AvgScore
                  WHERE   item   =   '气质与仪表 ')   t7
WHERE   t0.KS_ID   *=   t1.KS_ID   AND   t0.KS_ID   *=   t2.KS_ID   AND   t0.KS_ID   *=   t3.KS_ID   AND  
            t0.KS_ID   *=   t4.KS_ID   AND   t0.KS_ID   *=   t5.KS_ID   AND   t0.KS_ID   *=   t6.KS_ID   AND  
            t0.KS_ID   *=   t7.KS_ID

谁帮我看看这句sql的错误在哪里?
Sql   server报错:Incorrect   syntax   near   the   keyword   'SELECT '.
  相关解决方案