mysql 查两个表之间的数据差集

发表于

SELECT mailbox_id FROM `co_user` left join 
(select mailbox_id as i from core_mailbox) as t1
on co_user.mailbox_id= t1.i where t1.i is NULL;

评论

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注