SQL 查询当前表不存在在另一张表中的数据

SELECT * FROM TABLE_1 WHERE (SELECT COUNT(1) FROM TABLE_2 WHERE TABLE_1.ID = TABLE_2.THE_ID ) = 0;