case when

动态插入数据

insert into formtable_main_322_dt5(mainid,sys_name,sys_admin,sys_power,is_valid,remark)
select (select id from formtable_main_322 where requestid = {?requestid})mainid,
sys,sys_admin,power,is_valid,remark from uf_RMS_users
where sys_user = (select xm from formtable_main_322 where requestid = {?requestid})