一个有趣的左链接问题！

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@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/519130/viewspace-916641/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/519130/viewspace-916641/