select t.id,case when
(select a.c from a, b where a.id = b.id and a.id=t.id) =
(select b.c from b,a where a.id = b.id and a.id=t.id)
then
'1'
else
'0'
end case
from a t;
，也可以使用存储过程及游标实现
SELECT DECODE(B.c,NULL,1,0),a.c FROM A,B
WHERE A.c=B.c(+)
UNION
SELECT DECODE(a.c,NULL,1,0),B.c FROM A,B
WHERE B.c=A.c(+)
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024