想问多表合并的一个问题

[vinson985]

同一个select，只是因为条件不一样 所以得到的结果不一样的

第一个结果
select CODE,TYPE,VALUE AS 'F117' FROM T1 where TYPE ='117'

结果预览
--------------------------------------------
CODE TYPE F117
============================================
AAAA 117 0.9985


第二个结果
select CODE,TYPE,VALUE AS 'F118' FROM T1 where TYPE ='118'

结果预览
--------------------------------------------
CODE TYPE F118
============================================
AAAA 118 0.5154



我想把这两个查询结果连起来 变成这样的显示
--------------------------------------------
CODE F117 F118
============================================
AAAA 0.5154 0.5154


怎么连？？

[开启时代]

select a.code,F117,F118
from (select CODE,TYPE,VALUE AS 'F117' FROM T1 where TYPE ='117') as a 
inner join (select CODE,TYPE,VALUE AS 'F118' FROM T1 where TYPE ='118') as b on a.code=b.code

[快溜]

select CODE, max(case when TYPE='117' then VALUE end) [117], max(case when TYPE='118' then VALUE end) [118] FROM T1 where TYPE in('117','118')

[快溜]

select CODE, max(case when TYPE='117' then VALUE end) [117], max(case when TYPE='118' then VALUE end) [118] FROM T1 group by code where TYPE in('117','118')

[dd_2012]

select a.CODE,TYPE,a.VALUE AS 'F117',b.VALUE AS 'F118'
FROM T1 a,T1 b where a.TYPE ='117' and b.TYPE ='118'