access 行转列 SQL语句怎么写

[swdipper]

原表：

我想要把表改成这样的：

SQL 语句怎么写？

[还在加载中灬]

这叫列转行 直接UNION ALL应该就可以了吧

SELECT ID,'A1' AS [项目],A1 AS [值]
UNION ALL
SELECT ID,'A2',A2
UNION ALL
SELECT ID,'A3',A3

[swdipper]

设原始表是b

SELECT ID,'A1' AS [项目], A1 AS [值]
FROM (SELECT ID, 'A1', A1 FROM b
UNION ALL
(SELECT ID,'A2',A2 FROM b)
UNION ALL
(SELECT ID,'A3',A3 FROM b)
)
ORDER BY ID

结果项目列的都是'A1' ，求解

[还在加载中灬]

SELECT * FROM
(
	SELECT ID,'A1' AS [项目],A1 AS [值]
	UNION ALL
	SELECT ID,'A2',A2
	UNION ALL
	SELECT ID,'A3',A3
)
ORDER BY ID

应该是这样

[swdipper]

搞定了 这个方法只能写死 谢谢

[还在加载中灬]

是只能写死，在MSSQL里面，就算用关键字也是写死 不想写死，可以用动态执行，只是ACCESS应该会有点区别

引用 4 楼 swdipper 的回复:

搞定了 这个方法只能写死 谢谢