select * from A join B on A.a1 <> B.a1 and A.c1 <> B.c1
如果没有id, select * from a ta where not exists(select * from a join b on a.a1=b.a1 and a.c1=b.c1 where a.a1=ta.a1 and a.c1=ta.c1) 如果有ID SELECT * FROM A WHERE ID NOT IN(SELECT A.ID FROM A JOIN B ON A.A1=B.A1 AND A.C1=B.C1)
select * from a ta where not exists(select * from a join b on a.a1=b.a1 and a.c1=b.c1 where a.a1=ta.a1 and a.c1=ta.c1)
如果有ID
SELECT * FROM A WHERE ID NOT IN(SELECT A.ID FROM A JOIN B ON A.A1=B.A1 AND A.C1=B.C1)