insert C select USERID,USERNAME,SEX,AGE,STATE from A where not exists(select 1 from B where a.USERID=b.USERID and a.USERNAME=b.USERNAME and a.SEX=b.SEX and a.AGE=b.age and a.STATE=b.STATE )
INSERT C SELECT userid,username,sex,age,state FROM a WHERE NOT EXISTS (SELECT 1 FROM b a.userid=userid and a.username=b.username AND a.sex=b.sex and a.age=b.age AND a.state=b.state )
insert C
select USERID,USERNAME,SEX,AGE,STATE
from A
where not exists(select 1 from B
where
a.USERID=b.USERID and a.USERNAME=b.USERNAME
and a.SEX=b.SEX and a.AGE=b.age and a.STATE=b.STATE
)
SELECT userid,username,sex,age,state
FROM a
WHERE NOT EXISTS
(SELECT 1 FROM b a.userid=userid and a.username=b.username
AND a.sex=b.sex and a.age=b.age AND a.state=b.state
)
select * from a
except
select * from b