连接来自同一表的两个选择查询

在SQLServer2005 +中可能使用PIVOT

SELECt ID, valueHeading1, valueHeading2FROM( SELECt * FROM dbo.test28 WHERe valueHeading IN ('valueHeading1', 'valueHeading2') ) x PIVOT (  MAX(value)  FOR valueHeading IN ([valueHeading1], [valueHeading2])  ) p