select sp_id,
calling_id,
owner_area_code,
dr_day,
period_id,
prod_id,
service_id,
test_flag,
service_type_id,
fee,
duration,
LOCAL_UNITS,
charge_units,
acct_TYPE_ID,
location_id,
dr_source
from DAT_DR_200701
where dr_day between '20070118' and '20070405'
union all
select sp_id,
calling_id,
owner_area_code,
dr_day,
period_id,
prod_id,
service_id,
test_flag,
service_type_id,
fee,
duration,
LOCAL_UNITS,
charge_units,
acct_TYPE_ID,
location_id,
dr_source
from DAT_DR_200702
where dr_day between '20070118' and '20070405'
union all
select sp_id,
calling_id,
owner_area_code,
dr_day,
period_id,
prod_id,
service_id,
test_flag,
service_type_id,
fee,
duration,
LOCAL_UNITS,
charge_units,
acct_TYPE_ID,
location_id,
dr_source
from DAT_DR_200703
where dr_day between '20070118' and '20070405'
union all
select sp_id,
calling_id,
owner_area_code,
dr_day,
period_id,
prod_id,
service_id,
test_flag,
service_type_id,
fee,
duration,
LOCAL_UNITS,
charge_units,
acct_TYPE_ID,
location_id,
dr_source
from DAT_DR_200704
where dr_day between '20070118' and '20070405'