E-mail :
select iv_date, ps_no, iv_prcode, iv_prname, iv_prstd, iv_ctcode, iv_ctname, iv_prcode, iv_prname, iv_prstd, iv_otqty, iv_otup, iv_otamt,
pr_code, pr_name, pr_std, pr_bcode
from iv, pr
where ((iv_date like '5/1/2014%')
or (iv_date like '5/2/2014%')
or (iv_date like '5/3/2014%')
or (iv_date like '5/4/2014%')
or (iv_date like '5/5/2014%')
or (iv_date like '5/6/2014%')
or (iv_date like '5/7/2014%')
or (iv_date like '5/8/2014%')
or (iv_date like '5/9/2014%')
or (iv_date like '5/10/2014%')
or (iv_date like '5/11/2014%')
or (iv_date like '5/12/2014%')
or (iv_date like '5/13/2014%')
or (iv_date like '5/14/2014%')
or (iv_date like '5/15/2014%')
or (iv_date like '5/16/2014%')
or (iv_date like '5/17/2014%')
or (iv_date like '5/18/2014%')
or (iv_date like '5/19/2014%')
or (iv_date like '5/20/2014%')
or (iv_date like '5/21/2014%')
or (iv_date like '5/22/2014%')
or (iv_date like '5/23/2014%')
or (iv_date like '5/24/2014%')
)
and iv_prcode*=pr_code
order by iv_date, iv_ctcode, ps_no