我有两个mysql表
TABLEA
colA1 colA2
1 whatever
2 whatever
3 whatever
4 whatever
5 whatever
6 whatever
第二个表基本上是从tableA派生的,但删除了一些行
tableB的
colB1 colB2
1 whatever
2 whatever
4 whatever
6 whatever
即
colC1 colC2
3 whatever
5 whatever
最佳答案
SELECT t1.*
FROM TableA t1 LEFT JOIN
TableB t2 ON t1.ID = t2.ID
WHERE t2.ID IS NULL