delete from sys_profession_user
where professionID='402880d9152076fb0115210e882c0001'
and userid in
(select userid from view_profession_user
where professionID='402880d9152076fb0115210e882c0001'
and [user] like 'u_%')
INSERT INTO sys_profession_user
(professionID
,userID)
SELECT p.id,u.id FROM sys_profession p,sys_user u;