【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“252.sql”一文,供大家参考学习
insert all
when WY_NUM = 'wy001' then
into mr.tb_wya11 (WY_NUM,NAME,SEX,AGE,EMPAY) values (WY_NUM,NAME,SEX,AGE,EMPAY)
when WY_NUM = 'wy003' then
into mr.tb_wyb11 (WY_NUM,NAME,SEX,AGE,EMPAY) values (WY_NUM,NAME,SEX,AGE,EMPAY)
else
into mr.tb_wyc11 (WY_NUM,NAME,SEX,AGE,EMPAY) values (WY_NUM,NAME,SEX,AGE,EMPAY)
select * from mr.tb_empay07;