I don't like xxx join. I only use standard thing for portability. [#4132642@0 -ROLIA.NET 相约加拿大网上社区 之 枫下论坛 & 枫下部落, 枫下论坛主坛 ]
I don't like xxx join. I only use standard thing for portability.
by
kenchow27
(凯包子)
at
2007.12.19 23:38
(#4132642@0)
If the following statement is not working for your case, I can only say it's Oracle's problem that forces user to conceive a workaround.
select * from A where exists (select * from B where b.c1<>a.c1 or b.c2<>a.c2)