摘要： --1 SELECT a.* FROM a LEFT JOIN b ON a.key = b.key WHERE (b.key IS NULL) --2 select *, case when (select count(*) from b where id = a.id)>0 then 1 else 0 end as flag from a --3 select id... 阅读全文