今天用sql去同步部分历史数据,需要用到一个求差集的sql
有一个会员表
一个会员账户表
获取没有账户的会员
SELECT m.pkMember FROM member m LEFT JOIN ( SELECT pkMember FROM account ) AS ac ON m.pkMember = ac.pkMember WHERE ac.pkMember IS NULL;