日期:2014-05-18  浏览次数:20909 次

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 &nbs