将两个表中的主键不同数据查找出来并添加到一张新表中的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;