insert into 表名
select a.imarkno,
substr(b.字段b,INSTR(b.字段b,',',1,1)+1,INSTR(b.字段b,',',1,2)-INSTR(b.字段b,',',1,1)-1),
substr(b.字段b,INSTR(b.字段b,',',1,2)+1,INSTR(b.字段b,',',1,3)-INSTR(b.字段b,',',1,2)-1),
substr(b.字段b,INSTR(b.字段b,',',1,3)+1,INSTR(b.字段b,',',1,4)-INSTR(b.字段b,',',1,3)-1),
b.wangzhanlx,
substr(b.domainname,INSTR(b.domainname,',',1,1)+1,INSTR(b.domainname,',',1,2)-INSTR(b.domainname,',',1,1)-1),
substr(b.domainname,INSTR(b.domainname,',',1,2)+1,INSTR(b.domainname,',',1,3)-INSTR(b.domainname,',',1,2)-1),
substr(b.domainname,INSTR(b.domainname,',',1,3)+1,INSTR(b.domainname,',',1,4)-INSTR(b.domainname,',',1,3)-1),
c.glsj,
c.glbp,
'ywtxdz'
from wzba_identifier a,wzba_mingchengfb b,wzba_beianfb c
where a.iba_id=b.mc_id and a.iba_id=c.ba_id;
上一篇:Oracle Tuning (Oracle 性能调整)的一些总结
下一篇:sql server中改变object的owner时需要注意一点