[load_grdList] select u.tan_cd , u.tan_nm , u.tan_rnm , u.auth_kbn AS auth_kbn , u.del_flg , u.user_pass , u.bu_cd , u.yakusyoku , u.email , u.sort_key , h1.han_name as bu_nm , u.kousu_keisu , u.kyuyo_satei_gaku , u.ext_rate1 , u.ext_rate2 from m_tanto u left join m_hanyo h1 on (h1.mst_kbn = '55' and h1.han_cd = u.bu_cd) order by sort_key, tan_cd [load_grdList2] select han_cd, han_name from m_hanyo where mst_kbn = '91' order by sort_key