select /*parallel(t1,10) parallel(t2,10)*/
t1.stat_day, t1.service_code,
t1.user_id,t2.area_id,t2.product_id,
t2.consume_day,t2.min_call,
t2.change_brand_time,
t2.away_time,t2.status
from mm_md_newservice_day t1 , mm_md_user_day t2
where t1.user_id=t2.user_id(+)
and t1.apply_date=20070528
and t1.day_number=28
and t1.stat_day=20070528
and t2.day_number(+)=28
and t2.stat_day(+)=20070528;
select /*parallel(t1,10) parallel(t2,10)*/
t1.stat_day, t1.service_code,
t1.user_id,t2.area_id,t2.product_id,
t2.consume_day,t2.min_call,
t2.change_brand_time,
t2.away_time,t2.status
from mm_md_newservice_day t1 left join mm_md_user_day t2
on t1.user_id=t2.user_id
and t1.apply_date=20070528
and t1.day_number=28
and t1.stat_day=20070528
and t2.day_number=28
and t2.stat_day=20070528;
[@more@]
t1.stat_day, t1.service_code,
t1.user_id,t2.area_id,t2.product_id,
t2.consume_day,t2.min_call,
t2.change_brand_time,
t2.away_time,t2.status
from mm_md_newservice_day t1 , mm_md_user_day t2
where t1.user_id=t2.user_id(+)
and t1.apply_date=20070528
and t1.day_number=28
and t1.stat_day=20070528
and t2.day_number(+)=28
and t2.stat_day(+)=20070528;
select /*parallel(t1,10) parallel(t2,10)*/
t1.stat_day, t1.service_code,
t1.user_id,t2.area_id,t2.product_id,
t2.consume_day,t2.min_call,
t2.change_brand_time,
t2.away_time,t2.status
from mm_md_newservice_day t1 left join mm_md_user_day t2
on t1.user_id=t2.user_id
and t1.apply_date=20070528
and t1.day_number=28
and t1.stat_day=20070528
and t2.day_number=28
and t2.stat_day=20070528;
[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/519130/viewspace-916641/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/519130/viewspace-916641/