mysql 查询存在一个表而不存在另一个表的数据

 
 select * from  B where (select count(1) as num from A where A.ID = B.ID) = 0