Access 2013 SQL中的TRANSFORM和PIVOT [英] TRANSFORM and PIVOT in Access 2013 SQL

问题描述

如何使用TRANSFORM和PIVOT函数从第一个表中获取第二个表:

How can I get second table from first table using TRANSFORM and PIVOT functions:

TABLE_01

Config_ID  |  ConfigField  |  ConfigValue
-----------------------------------------
       11  |         Name  |        Basic
       11  |      Version  |         1.01
       11  |        Owner  |         Jack
       12  |         Name  |     Advanced
       12  |      Version  |         1.03
       12  |        Owner  |         Andy

TABLE_02

Config_ID  |      Name  |  Version  |  Owner
--------------------------------------------
       11  |     Basic  |     1.01  |  Jack
       12  |  Advanced  |     1.03  |  Andy

我正在尝试:

TRANSFORM ConfigValue
SELECT Config_ID
FROM TABLE_01
GROUP BY Config_ID
PIVOT ConfigField  

但出现错误:

您的查询不包含指定的表达式'ACValue' 聚合函数."

"Your query does not include the specified expression 'ACValue' as part of aggregate function."

推荐答案

我自己找到了解决方案:

I have found solution by myself:

TRANSFORM FIRST(ConfigValue)
SELECT Config_ID
FROM TABLE_01
GROUP BY Config_ID
PIVOT ConfigField

感谢大家的帮助.

这篇关于Access 2013 SQL中的TRANSFORM和PIVOT的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！