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博客 ” ，链接：https://blog.itpub.net/519130/viewspace-916641/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
SQL*Plus常用命令
请登录后发表评论
登录
全部评论
-
博文量54
-
访问量930636
