insert into gams02_department (dept_cntact_1_n)
select user_id_c as dept_cntact_1_n from gams01_user where user_name_n='大头'
select user_id_c as dept_cntact_1_n from gams01_user where user_name_n='大头'
select user_id_c from gams01_user where user_name_n='大头'
select user_id_c as dept_cntact_1_n from gams01_user where user_name_n='大头'
select @s=user_id_c
from gams01_user
where user_name_n='大头'insert into gams02_department (dept_cntact_1_n) values (@s)