初步怀疑可能是:select * from (select first 1 a.id,a.ddtime from hf a,stu b where a.stuid=b.stuid and a.ddtime between '03/01/2014' and '04/08/2014' and length(a.tel)>11) union select * from (select first 1 a.id,a.ddtime from hf a,stu b where a.stuid=b.stuid and a.ddtime between '03/01/2014' and '04/08/2014' and a.tel='')这个查询出来的结果集跟目标表“lw”对应的列不匹配
insert lw select * from ( select * from (select first 1 a.id,a.ddtime from hf a,stu b where a.stuid=b.stuid and a.ddtime between '03/01/2014' and '04/08/2014' and length(a.tel)>11) union select * from (select first 1 a.id,a.ddtime from hf a,stu b where a.stuid=b.stuid and a.ddtime between '03/01/2014' and '04/08/2014' and a.tel='') )
a.stuid=b.stuid and a.ddtime between '03/01/2014' and '04/08/2014' and length(a.tel)>11)
union
select * from (select first 1 a.id,a.ddtime from hf a,stu b where
a.stuid=b.stuid and a.ddtime between '03/01/2014' and '04/08/2014' and a.tel='')这个查询出来的结果集跟目标表“lw”对应的列不匹配
select * from (
select * from (select first 1 a.id,a.ddtime from hf a,stu b where
a.stuid=b.stuid and a.ddtime between '03/01/2014' and '04/08/2014' and length(a.tel)>11)
union
select * from (select first 1 a.id,a.ddtime from hf a,stu b where
a.stuid=b.stuid and a.ddtime between '03/01/2014' and '04/08/2014' and a.tel='')
)