连接表

select* from
(select * from user_application_customize where user_id = 100134) a,product_application_cfg b
where a.app_id(+)=b.app_id

 

与

select * from
 user_application_customize a,product_application_cfg b
where a.user_id=100134 and a.app_id(+)=b.app_id

 

下一句  外连就失去了作用。