[selectRecords]
select 
	uh.den_no,
	uh.henpin_flg,
	(1+um.row_no) as row_no,
	to_char(to_date(uh.input_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as input_ymd,
	to_char(to_date(uh.syori_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as syori_ymd,
	uh.zeinuki_gaku,
	uh.zei_gaku,
	uh.tok_tan,
	uh.zeikomi_gaku,
	uh.biko1 as u_biko1,
	uh.biko1 as u_biko1,
	uh.jucyu_no,
	um.hin_cd,
	replace(um.hin_nm,chr(10),'')as hin_nm,
	um.tok_hacyu_no,
	um.suryo,
	um.tanka,
	um.kingaku,
	to_char(to_date(um.nonyu_ymd, 'YYYYMMDD'), 'yyyy/mm/dd') as nonyu_ymd,
	uh.tok_cd,
	t.tok_nm,
	'��'||substr(t.zip_no,1,3)||'-'||substr(t.zip_no,4,7) as yubin_no,
	coalesce(cast(um.jucyu_no as varchar(10)),'')||'-'|| coalesce (cast(um.row_no as varchar(10)),'') as jucyu_row_no,
	t.addr1,
	t.addr2,
	t.addr3,
	t.addr4,
	coalesce(t.addr3,'')||coalesce(t.addr4,'') as addr3_4,	t.tori_cond,
	t.biko1,
	t.biko2,
	t.biko3,
	t.biko4,
	uh.nonyu_nm,
	'��'||substr(nonyu_zip_no,1,3)||'-'||substr(nonyu_zip_no,4,7) as nonyu_yubin_no,
	uh.nonyu_addr1,
	uh.nonyu_addr2,
	uh.nonyu_addr3,
	uh.nonyu_addr4,
	uh.nonyu_tan
from t_uri uh
left join m_tokui t on(uh.tok_cd = t.tok_cd)
left join t_uri_m um on(uh.den_no = um.den_no)
where 1 = 1
and uh.jucyu_flg = 0
and ((uh.syori_ymd >= '&1') or ('&1' = ''))
and ((uh.syori_ymd <= '&2') or ('&2' = ''))
and ((cast(uh.den_no as char(6)) = '&3') or ('&3' = ''))
and ((uh.tok_cd = '&4') or ('&4' = ''))
and ((um.hin_nm like '%&5%') or ('&5' = ''))
order by uh.den_no,um.row_no;