SELECT
BT010.IDHINMOKU as IDHINMOKU
,BT010.TXHINBAN as TXHINBAN
,BT010.TXHINMEI as TXHINMEI
,BT010.KBHINSYU as KBHINSYU
,BT010.KBUNIT as KBUNIT
,BT010.KBUNITPUR as KBUNITPUR
,BT010.VLKANZAN as VLKANZAN
,BT010.PRHANBAI
,BT010.PRKOUNYU
,BT010.IDSIIRESAKI
,KBUNIT_VAL.DSP1 as KBUNIT_VAL
,KBUNITPUR_VAL.DSP1 as KBUNITPUR_VAL
FROM
BT010
LEFT JOIN TLN_M_HANYO_CODE_MAIN KBUNIT_VAL ON KBUNIT_VAL.SIKIBETU_CODE = 'KBUNIT' AND KBUNIT_VAL.KEY_CODE = BT010.KBUNIT
LEFT JOIN TLN_M_HANYO_CODE_MAIN KBUNITPUR_VAL ON KBUNITPUR_VAL.SIKIBETU_CODE = 'KBUNIT' AND KBUNITPUR_VAL.KEY_CODE = BT010.KBUNITPUR
WHERE BT010.FGKOUNYU = 'T'