sql1

SELECT CNCNO1||CNCNO2||CNCNO3||CNCNO4||CNCNO5 as CNNO,
CNSLKI as SLKI,
CNCST1 as CST1,
CNCST2 as CST2,
CSCTRJ as CSNM,
CNTRCD as TRCD,
KUKNMJ as TRNM,
CNDOCC as DOCC,
CNSHKN as SHKN,
CNZNKN as ZNKN,

FROM customerhouse

LEFT OUTER JOIN customer on
CNCST1 = CSCST1
AND CNCST2 = CSCST2
LEFT OUTER JOIN KUBNMR
ON KUKBNC = 'B6'
AND KUDLTM = ''
WHERE
TRIM(CNCNO1)||TRIM(CNCNO2)||TRIM(CNCNO3)||TRIM(CNCNO4)||TRIM(CNCNO5) = '5'