oracle的full join关联的表限制条件在on后面与限制在子查询的结果是不一样

create table test_a(

id number,

name varchar2(10)

);

create table test_b(

id number,

name varchar2(10)

);

select * from test_a a full join test_b b on a.id=b.id and b.id=3 order by a.id,b.id;

select * from test_a a full join (select * from test_b where id=3) b on a.id=b.id order by a.id,b.id;

如果left join的情况查询的结果数据是一致的：

select * from test_a a left join test_b b on a.id=b.id and b.id=3 order by a.id,b.id;

select * from test_a a left join(select * from test_b where id=3) b on a.id=b.id order by a.id,b.id;