[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
, u.mob_no
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




