sql8

SELECT
ac.ANRKNM,
ac.ANTRN5,
ac.ANTRN6,
ac.ANTRN7,
ac.ANTRN8,
ac.ANKIKN,
kb1.KUKNMR as KUKNMR1,
ac.ANKATA,
ac.ANOPTD,
ac.ANTEMP,
ac.ANFIL1,
ac.ANTOSO,
ac.ANUCHI,
ac.ANTKCD,
tk.TLTKNM,
ac.ANEIGK,
eg.EAEINM,
bk.BKBYC1,
bk.BKBYC2,
cs.CSCTRJ,
bl1.BLTHKC,
kb2.KUKNMR as KUKNMR2,
bl1.BLTEKC,
kb3.KUKNMR as KUKNMR3,
bk.BKBYKN,
bl1.BLYKD2,
bk.BKBYD1,
bk.BKBYND,
bk.BKSQNO,
bk.BKCNO1,
bk.BKCNO2,
bk.BKCNO3,
bk.BKCNO4,
bk.BKCNO5,
bk.BKSLKI,
bk.BKATNO,
bk.BKSTXB,
bk.BKBYD2

FROM BAIKAK bk
INNER
JOIN ACNTRA ac
ON(
ac.ANCNO1= bk.BKCNO1 AND
ac.ANCNO2= bk.BKCNO2 AND
ac.ANCNO3= bk.BKCNO3 AND
ac.ANCNO4= bk.BKCNO4 AND
ac.ANCNO5= bk.BKCNO5
AND
ac.ANSLKI= bk.BKSLKI AND
ac.ANDLTM= ''
) LEFT OUTER JOIN KUBNMR kb1
ON(
kb1.KUKBNC = 'V2' AND
RIGHT(TRIM(kb1.KUCODE),INT(kb1.KULENG)) =
ac.ANKIKN AND
kb1.KUDLTM = ' ' AND
kb1.KUSYMD ='7' AND
kb1.KUEYMD ='7'
) LEFT OUTER JOIN TOKYMR tk
ON(
tk.TLTKCD =
ac.ANTKCD AND
tk.TLDLTM = '' AND
tk.TLSYMD ='7' AND
tk.TLEYMD ='7'
) LEFT OUTER JOIN EIGSMR eg
ON(
eg.EATKCD =
ac.ANTKCD AND
eg.EAEIGK = ac.ANEIGK AND
eg.EADLTM = '' AND
eg.EASYMD
='7'
eg.EAEYMD ='7'
)LEFT OUTER JOIN
CUSTMR cs
ON(
cs.CSCST1 = bk.BKBYC1 AND
cs.CSCST2 = bk.BKBYC2 AND
cs.CSDLTM = ''
) LEFT OUTER JOIN BCLTRN bl1
ON(
bl1.BLBYND = bk.BKBYND
AND
bl1.BLSQNO = bk.BKSQNO AND
bl1.BLKIZI = '1' AND
bl1.BLDLTM = ''
) LEFT
OUTER JOIN BCLTRN bl2
ON(
bl2.BLBYND = bk.BKBYND AND
bl2.BLSQNO =
bk.BKSQNO AND
(bl2.BLFL10 != 'K' OR
bl2.BLUPFL != 'U' ) AND
bl2.BLDLTM =
''
) LEFT OUTER JOIN KUBNMR kb2
ON(
kb2.KUKBNC = 'D2' AND
RIGHT(TRIM(kb2.KUCODE),INT(kb2.KULENG)) = bl1.BLTHKC AND
kb2.KUDLTM =
''
AND
kb2.KUSYMD ='7' AND
kb2.KUEYMD ='7'
)
LEFT OUTER JOIN KUBNMR kb3
ON(
kb3.KUKBNC= 'D3' AND
RIGHT(TRIM(kb3.KUCODE),INT(kb3.KULENG))= bl1.BLTEKC AND
kb3.KUDLTM = ''
AND
kb3.KUSYMD ='7'AND
kb3.KUEYMD ='7'
)LEFT OUTER JOIN (
SELECT
sj1.SJCNO1, sj1.SJCNO2, sj1.SJCNO3,
sj1.SJCNO4, sj1.SJCNO5, sj1.SJSLKI
FROM SAIKNJ
sj1
WHERE
(sj1.SJNKSB
='108' OR sj1.SJNKSB ='109' OR sj1.SJNKSB ='110'
OR sj1.SJNKSB ='130')
AND sj1.SJDLTM = ''
GROUP BY sj1.SJCNO1,
sj1.SJCNO2, sj1.SJCNO3,
sj1.SJCNO4, sj1.SJCNO5, sj1.SJSLKI ) sj
ON(
sj.SJCNO1 = bk.BKCNO1
AND
sj.SJCNO2 = bk.BKCNO2
AND sj.SJCNO3 = bk.BKCNO3
AND sj.SJCNO4 =
bk.BKCNO4
AND sj.SJCNO5 = bk.BKCNO5
AND sj.SJSLKI = bk.BKSLKI
) LEFT
OUTER JOIN SAIKNJ sj2
ON(
sj2.SJCNO1 = bk.BKCNO1
AND sj2.SJCNO2 =
bk.BKCNO2
AND sj2.SJCNO3 = bk.BKCNO3
AND sj2.SJCNO4 = bk.BKCNO4
AND
sj2.SJCNO5 = bk.BKCNO5
AND sj2.SJSLKI = bk.BKSLKI
AND sj2.SJNKK2 != 0
AND ( (sj2.SJNKSB = '108')
OR (sj2.SJNKSB ='109')
OR (sj2.SJNKSB ='110')
OR (sj2.SJNKSB ='130') )
AND sj2.SJDLTM= ''
)
WHERE
bk.BKDLTM = ''
AND
bk.BKSLKI = ='7'
AND

bk.BKBYD1 ='7'
AND
bk.BKBYD1 ='7'
AND

ac.ANTKCD ='7'


AND bl2.BLBYND IS NULL AND
sj.SJCNO1 IS NOT NULL AND
sj2.SJCNO1 IS NULL
ORDER BY
bk.BKCNO1 ASC,
bk.BKCNO2 ASC,
bk.BKCNO3 ASC,
bk.BKCNO4 ASC,
bk.BKCNO5 ASC,
bk.BKSLKI ASC,
bk.BKATNO ASC