(+)要放在从表上
select t1.*,t2.* from test1 t1 left join test2 t2 on t1.id = t2.id
等同于
select t1.*,t2.* from test1 t1,test2 t2 where t1.id = t2.id(+)
注意:
如果在进行多次分组统计where后面是用(+)进行外连接的会对结果继续过滤不受+号的控制
(+)要放在从表上
select t1.*,t2.* from test1 t1 left join test2 t2 on t1.id = t2.id
等同于
select t1.*,t2.* from test1 t1,test2 t2 where t1.id = t2.id(+)
注意:
如果在进行多次分组统计where后面是用(+)进行外连接的会对结果继续过滤不受+号的控制