17,377
社区成员
发帖
与我相关
我的任务
分享
select a.*, b.dw, b.nd, b.ktxm, b.gq, b.sjcxs, b.sjdw, b.bxr
from CD_ATTACHMENT_JOURNAL a,
(select ttachment_journal_id,
max(decode(wjsymc, 'DW', wjsyz, null)) DW,
max(decode(wjsymc, 'ND', wjsyz, null)) ND,
max(decode(wjsymc, 'KTXM', wjsyz, null)) KTXM,
max(decode(wjsymc, 'GQ', wjsyz, null)) GQ,
max(decode(wjsymc, 'SJCXS', wjsyz, null)) SJCXS,
max(decode(wjsymc, 'SJDW', wjsyz, null)) SJDW,
max(decode(wjsymc, 'BXR', wjsyz, null)) BXR
from epdm_bgwd_sy
group by ttachment_journal_id) b
where a.ttachment_journal_id = b.ttachment_journal_id(+)
and a.flid = '003'