sql2

SELECT NTSNT1||NTSNT2||NTSNT3 as NTSNT,

NTIJTX,NTTIYC,NTFOIF,NTJOTI,
NTACCD,NTONKB,NTSSCD,NTULCD,
NTSIPK,NTORIT,NTIJKN,NTIJKT,
NTGTLS,NTGTLT,NTMTLS,NTMTLT,
k1.KUKNMR as
TRCDNM,
k2.KUKNMR as JOTINM,
k3.KUKNMR as ACCDNM,
k4.KUKNMR as SSCDNM,
k5.KUKNMR as ULCDNM

FROM NA110T

LEFT OUTER JOIN KUBNMR k1 on
(
k1.KUKBNC = 'B6'
AND
RIGHT(TRIM(k1.KUCODE),INT(k1.KULENG)) = NTTRCD
AND k1.KUSYMD
AND k1.KUDLTM = ''
)

LEFT
OUTER
JOIN KUBNMR k2 on
(
k2.KUKBNC = '0'
AND
RIGHT(TRIM(k2.KUCODE),INT(k2.KULENG)) = NTJOTI

AND k2.KUDLTM = ''
)
LEFT
OUTER JOIN KUBNMR k3 on
(
k3.KUKBNC = 'X5'
AND
RIGHT(TRIM(k3.KUCODE),INT(k3.KULENG)) = NTACCD

AND k3.KUDLTM = ''
)
LEFT
OUTER JOIN
KUBNMR k4 on
(
k4.KUKBNC = 'LK'
AND
RIGHT(TRIM(k4.KUCODE),INT(k4.KULENG)) = NTSSCD

AND k4.KUDLTM = ''
)

LEFT
OUTER JOIN KUBNMR k5 on
(
k5.KUKBNC = 'X5'
AND
RIGHT(TRIM(k5.KUCODE),INT(k5.KULENG)) = NTULCD
AND k5.KUSYMD <=

AND k5.KUDLTM = ''
)
WHERE
TRIM(NTCNO1)||TRIM(NTCNO2)||TRIM(NTCNO3)||TRIM(NTCNO4)||TRIM(NTCNO5) = '8'
AND NTSLKI = '8'
AND
NTDLTM = ''