17,140
社区成员




select
max(decode(表1.xq,to_char(to_date('20141201','yyyymmdd'),'d'),decode(表1.sfxx,1,表2.姓名))) as "20141201",
max(decode(表1.xq,to_char(to_date('20141202','yyyymmdd'),'d'),decode(表1.sfxx,1,表2.姓名))) as "20141202",
max(decode(表1.xq,to_char(to_date('20141203','yyyymmdd'),'d'),decode(表1.sfxx,1,表2.姓名))) as "20141203"
from 表1,表2
where 表1.bh=表2.bh
group by 表1.bh
列不固定的话,需要在应用程序中动态拼接,或是在数据库中动态创建视图实现