sql server 2008 转置

select distinct aa as 姓名,bc as 语文,cc as 数学 from 表1 a inner join (select a,c from 表1 where b='语文') b on aa=ba inner join (select a,c from 表1 where b='数学') c on aa=ca
这样就OK了

---