BODY_SQLBLOCK 1 [CARD] 1058字
SELECT
YT010.DTNEND as DTNEND
,case when YT010.AMKIKANURI is null then 0 else YT010.AMKIKANURI end as AMKIKANURI
,case when YT010.AMKIKANJYU is null then 0 else YT010.AMKIKANJYU end as AMKIKANJYU
,case when YT010.AMURIKAKE is null then 0 else YT010.AMURIKAKE end as AMURIKAKE
,case when YT010.AMKIKANARARI is null then 0 else YT010.AMKIKANARARI end as AMKIKANARARI
,case when YT010.AMKIKANKAI is null then 0 else YT010.AMKIKANKAI end as AMKIKANKAI
,case when YT010.AMKIKANSIHA is null then 0 else YT010.AMKIKANSIHA end as AMKIKANSIHA
,case when YT010.AMKAIKAKE is null then 0 else YT010.AMKAIKAKE end as AMKAIKAKE
,case when YT010.AMKIKANNYUKO is null then 0 else YT010.AMKIKANNYUKO end as AMKIKANNYUKO
,case when YT010.AMKIKANSYUKKO is null then 0 else YT010.AMKIKANSYUKKO end as AMKIKANSYUKKO
,case when YT010.AMZAIKO is null then 0 else YT010.AMZAIKO end as AMZAIKO
,case when YT010.AMKIKANSEI is null then 0 else YT010.AMKIKANSEI end as AMKIKANSEI
FROM
YT010
BODY_SQLBLOCK 2 [LIST] 1079字
SELECT
YT020.DTNEND as DTNEND
,YT020.DTMSEQ
,case when YT020.AMKIKANURI is null then 0 else YT020.AMKIKANURI end as AMKIKANURI
,case when YT020.AMKIKANJYU is null then 0 else YT020.AMKIKANJYU end as AMKIKANJYU
,case when YT020.AMURIKAKE is null then 0 else YT020.AMURIKAKE end as AMURIKAKE
,case when YT020.AMKIKANARARI is null then 0 else YT020.AMKIKANARARI end as AMKIKANARARI
,case when YT020.AMKIKANKAI is null then 0 else YT020.AMKIKANKAI end as AMKIKANKAI
,case when YT020.AMKIKANSIHA is null then 0 else YT020.AMKIKANSIHA end as AMKIKANSIHA
,case when YT020.AMKAIKAKE is null then 0 else YT020.AMKAIKAKE end as AMKAIKAKE
,case when YT020.AMKIKANNYUKO is null then 0 else YT020.AMKIKANNYUKO end as AMKIKANNYUKO
,case when YT020.AMKIKANSYUKKO is null then 0 else YT020.AMKIKANSYUKKO end as AMKIKANSYUKKO
,case when YT020.AMZAIKO is null then 0 else YT020.AMZAIKO end as AMZAIKO
,case when YT020.AMKIKANSEI is null then 0 else YT020.AMKIKANSEI end as AMKIKANSEI
FROM
YT020