第1个回答 2013-01-31
select A.*
from A,B
WHERE A.ID= B.ID
AND A.a<>B.b;
第2个回答 2013-02-01
①select * from A where a not in (
select b from B)
② select a from A
minus
select b from B
第3个回答 2013-01-31
select * from A where a not in (
select b from B)本回答被提问者采纳