insert into userstate(NUSERID,USERCODE,CREATETIME,USERSTATE,ACCOUNTSTATE,UPDATETIME,UPDATEPASSWORD) select NUSERID,USERCODE,'2018/12/13',1,0,'2018/12/13','2018/12/13' from user where USERCODE in (select USERCODE from fsys_USER EXCEPT select USERCODE from fsys_userstate);
'2018/12/13',1,0,'2018/12/13','2018/12/13',字段值可以不来自user表;
NUSERID,USERCODE,来自user表;