insert into wcmuser(userid,username,truename,status,password)
select id as userid,user_name,user_name_zh as truename ,status ,'25D55AD283AA400'
from
(
select id,user_name,user_name_zh, 30 as status
from cmccitil.t_user
where id>10000
and id not in
(
select b.id
from trsdba.wcmuser a,
cmccitil.t_user b
where a.username = b.user_name
)
)
select * from wcmuser