将两个表中的主键不同数据查找出来并添加到一张新表中的sql示例

//将两个表中的主键不同数据查找出来并添加到一张新表中

INSERT INTO t_user SELECT usera.userid, usera.name, usera.department, usera.position, usera.mobile, usera.gender, usera.email, usera.weixinid, usera.enable, usera.avatar, usera.status, usera.creattime, usera.updatetime, usera.creatuser FROM (SELECT a.* FROM t_user_temp a WHERE NOT EXISTS ( SELECT * FROM t_user_temp c INNER JOIN t_user b ON c.userid = b.userid WHERE a.userid = b.userid ) ) usera;