SELECT
BT010.IDHINMOKU as IDHINMOKU
,BT010.TXHINBAN as TXHINBAN
,BT010.TXHINMEI as TXHINMEI
,BT010.KBHINSYU as KBHINSYU
,BT010.FGZAIKO as FGZAIKO
,BT010.FGKOUNYU as FGKOUNYU
,BT010.FGHANBAI as FGHANBAI
,BT010.FGSEIZO as FGSEIZO
,BT010.KBUNIT as KBUNIT
,BT010.KBUNITPUR as KBUNITPUR
,BT010.VLKANZAN as VLKANZAN
,BT010.PRHANBAI
,BT010.PRKOUNYU
,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.FGSEIZO = 'T'