sql7

SELECT
SHBMCD, BNBNA AS SHBMCDNM, SHTNTO, TNBNA AS SHTNTONM, SHSHNO, SHSNT1, SHSNT2, SHSNT3, SHAD01, K1.KUKNMR AS KUKNMR01,
SHCST1, SHCST2, SHHNNA, SHTKCD, PSCUS1, PSCUS2, C1.CSCTRJ AS CSCTRJ01, SHKYYD, SUBSTR(DIGITS(SHS027), 2, 1) AS SHS027,
A1.ABKNMR AS ABKNMR01, SHSA47, SHSB47, C2.CSCTRJ AS CSCTRJ02, C3.CSCTRJ AS CSCTRJ03, NLSA47, NLSB47, C4.CSCTRJ AS CSCTRJ04,
NLA201, NLB201, C5.CSCTRJ AS CSCTRJ05, SHCHOH, K2.KUKNMR AS KUKNMR02, CKST01, K3.KUKNMR AS KUKNMR03, SSTEKC, K4.KUKNMR AS KUKNMR04,
K5.KUKNMR AS KUKNMR05, K6.KUKNMR AS KUKNMR06, SHSHSO, SHZNKA, SHKUBN, SHDAIR,
PSTNS1, T1.TPTPNM AS TPTPNM01,
PSTNS2, T2.TPTPNM AS TPTPNM02,
PSTNS3, T3.TPTPNM AS TPTPNM03,
PSTNS4, T4.TPTPNM AS TPTPNM04,
PSTNS5, T5.TPTPNM AS TPTPNM05,
PSHAM1, PSHAM2, PSHAM3, PSHAM4, PSHAM5,
PSHS11, PSHS12, C11.CSCTRJ AS CSCTRJ11,
PSHS21, PSHS22, C12.CSCTRJ AS CSCTRJ12,
PSHS31, PSHS32, C13.CSCTRJ AS CSCTRJ13,
PSHS41, PSHS42, C14.CSCTRJ AS CSCTRJ14,
PSHS51, PSHS52, C15.CSCTRJ AS CSCTRJ15,
PSTOK1, G1.TTTKNM AS TTTKNM01,
PSTOK2, G2.TTTKNM AS TTTKNM02,
PSTOK3, G3.TTTKNM AS TTTKNM03,
PSTOK4, G4.TTTKNM AS TTTKNM04,
PSTOK5, G5.TTTKNM AS TTTKNM05,
SHS011, SHS015, SHS016, SHS018, SHS019, SHS020, SHS022, SHS01T, SHYDT1, SHYDT3, SHKKIK, SHKAIE, SHKJOK, SHENTI, SHKAIS,
SHKJRT, SHESDS, CMNMRC, NLAMNM, NLKATA, NLOPTD, NLTEMP, NLTOSO, NLUCHI, NLAYOT, NLATYP, SHLKIK, SHVNP1, SHVNC1, SHCSGP, SHCHO3
    FROM SANTEH
        LEFT OUTER JOIN KSANFL ON NLMKN1 = SHSNT1 AND NLMKN2 = SHSNT2 AND NLMKN3 = SHSNT3 AND NLDLTM = ''
        LEFT OUTER JOIN BMNMTR ON BNBCD = SHBMCD AND BNSYMD ='5'AND BNEYMD ='5'AND BNDLTM = ''
        LEFT OUTER JOIN TANTMR ON TNBCD = SHBMCD AND TNTCD = SHTNTO AND TNSYMD ='5' AND TNEYMD ='5' AND TNDLTM = ''
        LEFT OUTER JOIN PRSLMR ON PSSHNO = SHSHNO AND PSDLTM = ''
        LEFT OUTER JOIN SEISKI ON SSSKC1 = PSCUS1 AND SSSKC2 = PSCUS2 AND SSSYMD ='5' AND SSEYMD ='5'AND SSDLTM = ''
        LEFT OUTER JOIN CDTMST ON CMFXID = 'GS005' AND CMCLAS = '2'
        LEFT OUTER JOIN CUSTMR C1 ON C1.CSCST1 = PSCUS1 AND C1.CSCST2 = PSCUS2 AND C1.CSDLTM = ''
        LEFT OUTER JOIN CUSTMR C2 ON C2.CSCST1 = SHSA47 AND C2.CSCST2 = SHSB47 AND C2.CSDLTM = ''
        LEFT OUTER JOIN CUSTMR C3 ON C3.CSCST1 = SHCST1 AND C3.CSCST2 = SHCST2 AND C3.CSDLTM = ''
        LEFT OUTER JOIN CUSTMR C4 ON C4.CSCST1 = NLSA47 AND C4.CSCST2 = NLSB47 AND C4.CSDLTM = ''
        LEFT OUTER JOIN CUSTMR C5 ON C5.CSCST1 = NLA201 AND C5.CSCST2 = NLB201 AND C5.CSDLTM = ''
        LEFT OUTER JOIN TNPOMR T1 ON T1.TPTPCD = PSTNS1 AND T1.TPSYMD ='5' AND T1.TPEYMD ='5' AND T1.TPDLTM = ''
        LEFT OUTER JOIN TNPOMR T2 ON T2.TPTPCD = PSTNS2 AND T2.TPSYMD ='5' AND T2.TPEYMD ='5'AND T2.TPDLTM = ''
        LEFT OUTER JOIN TNPOMR T3 ON T3.TPTPCD = PSTNS3 AND T3.TPSYMD ='5' AND T3.TPEYMD ='5'AND T3.TPDLTM = ''

        LEFT OUTER JOIN CUSTMR C11 ON C11.CSCST1 = PSHS11 AND C11.CSCST2 = PSHS12 AND C11.CSDLTM = ''
        LEFT OUTER JOIN CUSTMR C12 ON C12.CSCST1 = PSHS21 AND C12.CSCST2 = PSHS22 AND C12.CSDLTM = ''
        LEFT OUTER JOIN CUSTMR C13 ON C13.CSCST1 = PSHS31 AND C13.CSCST2 = PSHS32 AND C13.CSDLTM = ''
        LEFT OUTER JOIN CUSTMR C14 ON C14.CSCST1 = PSHS41 AND C14.CSCST2 = PSHS42 AND C14.CSDLTM = ''
        LEFT OUTER JOIN CUSTMR C15 ON C15.CSCST1 = PSHS51 AND C15.CSCST2 = PSHS52 AND C15.CSDLTM = ''
        LEFT OUTER JOIN TKGKMR G1 ON G1.TTTONO = PSTOK1 AND G1.TTSYMD ='5' AND G1.TTEYMD ='5'AND G1.TTDLTM = ''
        LEFT OUTER JOIN TKGKMR G2 ON G2.TTTONO = PSTOK2 AND G2.TTSYMD ='5' AND G2.TTEYMD ='5' AND G2.TTDLTM = ''
        LEFT OUTER JOIN TKGKMR G3 ON G3.TTTONO = PSTOK3 AND G3.TTSYMD ='5'AND G3.TTEYMD ='5'AND G3.TTDLTM = ''
     
        LEFT OUTER JOIN CDKALS ON CKSBSB = 'CL' AND CKFXID = 'KCL0040E' AND CKGMID = '11' AND CKKEY1 = 'CHK005' AND CKKEY2 = SHCHOH AND CKKEY3 = '' AND CKKEY4 = '' AND CKKEY5 = '' AND CKUSEK = '1' AND CKSEQN = 1 AND CKSYMD ='5'AND CKEYMD ='5'
        LEFT OUTER JOIN AKBNMR A1 ON A1.ABKBNC = 'A5' AND SUBSTR(A1.ABDTCD, 2, 1) = SUBSTR(DIGITS(SHS027), 2, 1) AND A1.ABDLTM = '' AND A1.ABSYMD ='5' AND A1.ABEYMD ='5'
    LEFT OUTER JOIN KUBNMR K1 ON K1.KUKBNC = 'B6' AND SUBSTR(K1.KUCODE, 2, 3) = SHAD01 AND K1.KUDLTM = '' AND K1.KUSYMD ='5' AND K1.KUEYMD ='5'
    LEFT OUTER JOIN KUBNMR K2 ON K2.KUKBNC = 'F5' AND SUBSTR(K2.KUCODE, 3, 2) = SHCHOH AND K2.KUDLTM = '' AND K2.KUSYMD ='5' AND K2.KUEYMD ='5'
    LEFT OUTER JOIN KUBNMR K3 ON K3.KUKBNC = 'D2' AND SUBSTR(K3.KUCODE, 3, 2) = SUBSTR(CKST01, 1, 2) AND K3.KUDLTM = '' AND K3.KUSYMD ='5'AND K3.KUEYMD ='5'
    LEFT OUTER JOIN KUBNMR K4 ON K4.KUKBNC = 'D3' AND SUBSTR(K4.KUCODE, 3, 2) = SSTEKC AND K4.KUDLTM = '' AND K4.KUSYMD ='5'AND K4.KUEYMD ='5'
    LEFT OUTER JOIN KUBNMR K5 ON K5.KUKBNC = 'D3' AND SUBSTR(K5.KUCODE, 3, 2) = 'Z2' AND K5.KUDLTM = '' AND K5.KUSYMD ='5'AND K5.KUEYMD ='5'
    LEFT OUTER JOIN KUBNMR K6 ON K6.KUKBNC = 'D3' AND SUBSTR(K6.KUCODE, 3, 2) = 'T1' AND K6.KUDLTM = '' AND K6.KUSYMD ='5' AND K6.KUEYMD ='5'
    WHERE SHSNT1 = '8'
        AND SHSNT2 =  '8'
        AND SHSNT3 = '8'