列转行加连接查询

**先通过列转行得到Value表转换后的
 (SELECT * FROM Valuetable AS v PIVOT ( SUM(Value) FOR v.ID_p IN (Phone,ID,Department))) AS T
然后通过内连接连接起来
SELECT P.ID_p, P.Name, P.Address,T.phone,T.ID,T.Department FROM Person AS P INNER JOIN (SELECT * FROM Valuetable AS v PIVOT ( SUM(Value) FOR v.ID_p IN (Phone,ID,Department))) AS T ON P.ID_p = T.ID_p;**