SELECT
BT010.IDHINMOKU as IDHINMOKU
,BT010.TXHINBAN as TXHINBAN
,BT010.TXHINMEI as TXHINMEI
,BT010.KBHINSYU as KBHINSYU
,BT010.IDSIIRESAKI as IDSIIRESAKI
,AT030.TXKANJI as TXKANJI
,BT010.PRGENKA as PRGENKA
,BT010.PRHANBAI as PRHANBAI
,BT010.PRKOUNYU as PRKOUNYU
,BT010.KBUNIT as KBUNIT
,BT010.KBUNITPUR as KBUNITPUR
,BT010.VLKANZAN as VLKANZAN
,BT010.FGZAIKO as FGZAIKO
,BT010.FGKOUNYU as FGKOUNYU
,BT010.FGHANBAI as FGHANBAI
,BT010.FGSEIZO as FGSEIZO
,BT010.TXTEKIYO as TXTEKIYO
,BT010.MODIFY_COUNT as MODIFY_COUNT
FROM
BT010 LEFT OUTER JOIN AT030
ON BT010.IDSIIRESAKI = AT030.IDTORIHIKISAKI
AND AT030.FGSIIRESAKI = 'T'