原文地址:https://blog.csdn.net/yongh701/article/details/51689976
select id from usertable
where id not in (select id from blog)
select id FROM usertable LEFT JOIN
(select id as i from blog) as t1
ON usertable.id=t1.i where t1.i IS NULL
原文地址:https://blog.csdn.net/yongh701/article/details/51689976
select id from usertable
where id not in (select id from blog)
select id FROM usertable LEFT JOIN
(select id as i from blog) as t1
ON usertable.id=t1.i where t1.i IS NULL