select * from bluecoco_temp1 a,bluecoco_temp2 b
where a.str1 =b.str1(+)
union
select * from bluecoco_temp1 a,bluecoco_temp2 b
where a.str1 (+)=b.str1
where a.str1 =b.str1(+)
union
select * from bluecoco_temp1 a,bluecoco_temp2 b
where a.str1 (+)=b.str1
where a.ProductID(+)=b.ProductID (+)
select * from A,B
where a.ProductID(+)=b.ProductID
union
select * from A,B
where a.ProductID=b.ProductID (+)
ERROR 位于第 1 行:
ORA-01468: 一个谓词只能引用一个外部连接表用outer join也不行,还是报错,结果就采用了union。
没想到有full outer join,学到了!