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;
