sql里面可以成功运行的语句。转到快表就难办了。不知道咋改改
- SELECT
- [学号],
- [身高],
- [体重],
- [肺活量],
- [跑50米],
- [立定跳远],
- [坐位体前屈],
- [跑800米],
- [跑1000米],
- [一分钟仰卧起坐],
- [引体向上]
- FROM
- (
- SELECT
- A.F_7 AS [学号],
- B.F_14 AS [项目名称],
- B.F_15 AS [体育成绩]
- FROM
- T_3 AS A
- LEFT JOIN T_4 AS B ON a.F_7 = b.F_51 where B.F_51 is not NULL
- ) AS C PIVOT (
- SUM ([体育成绩]) FOR [项目名称] IN (
- [身高],
- [体重],
- [肺活量],
- [跑50米],
- [立定跳远],
- [坐位体前屈],
- [跑800米],
- [跑1000米],
- [一分钟仰卧起坐],
- [引体向上]
- )
- ) AS D
复制代码 这个语句的内容,我是需要 在本报表(T_18) 里面填入。 具体该如何修改下? 谢谢大家帮助! |
|
monvzhilei