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'.
这个查询语句是想把VIEW_KS_AvgScore这个视图里的数据横排过来。。。。
(VIEW_KS_AvgScore)
KS_ID KS_Name PF_Name Value
628 李明 计划、组织能力 20
628 李明 拟任岗位的匹配性 12
628 李明 气质与仪表 8
628 李明 人际交往与协调能力 16
628 李明 应变能力 14
628 李明 语言表达能力 10
628 李明 综合分析能力 20