有种SQL语法叫PIVOT. http://dev.yesky.com/394/2429894.shtml供参考 如果你的多项值是可数的,也可用union 如:表: ID Q1 Q2 1 4 1,2,3CREATE VIEW A AS SELECT [Q1],'1' as [Q2] FROM TEST1 WHERE ','+[Q2]+',' LIKE '%,1,%' UNION SELECT [Q1],'2' as [Q2] FROM TEST1 WHERE ','+[Q2]+',' LIKE '%,2,%' UNION SELECT [Q1],'3' as [Q2] FROM TEST1 WHERE ','+[Q2]+',' LIKE '%,3,%'可得到:ID Q1 Q2 1 4 1 1 4 2 1 4 3
http://dev.yesky.com/394/2429894.shtml供参考
如果你的多项值是可数的,也可用union
如:表:
ID Q1 Q2
1 4 1,2,3CREATE VIEW A
AS
SELECT [Q1],'1' as [Q2] FROM TEST1 WHERE ','+[Q2]+',' LIKE '%,1,%'
UNION
SELECT [Q1],'2' as [Q2] FROM TEST1 WHERE ','+[Q2]+',' LIKE '%,2,%'
UNION
SELECT [Q1],'3' as [Q2] FROM TEST1 WHERE ','+[Q2]+',' LIKE '%,3,%'可得到:ID Q1 Q2
1 4 1
1 4 2
1 4 3