摘要：
1 select * from TbaleOne 2 unpivot(qty for years in ([2002],[2003],[2004])) as up 3 go 4 5 select * from TableTwo 6 unpivot(grate for subject in [kemu 阅读全文
摘要：
1 SELECT * FROM TableA INNER JOIN TableB 2 ON TableA.name = TableB.name 3 id name id name 4 -- ---- -- ---- 5 1 Pirate 2 Pirate 6 3 Ninja 4 Ninja 7 8 阅读全文