论坛 › Informix › 关于临时表的问题

B06022208 发表于 2010-11-02 15:20

关于临时表的问题

本帖最后由 B06022208 于 2010-11-02 15:37 编辑

select
t1.policyno,t1.insuredname ||' ',t1.appliname ||' ',t1.operatedate,
t1.startdate,t1.enddate,
t1.licenseno ||' ',t1.engineno ||' ' ,t1.sumamount,t1.sumpremium,
t1.handler1code
from prpcmain t1
where comcode = '320112'
and riskcode = 'D'
and startdate between '20091001' and '20091031'
--and sfxinb = '1'
and underwriteflag in ('1','3')
and othflag !='1'
into temp t1;
我在使用上面语句在informix提数时，出现Virtual column must have explicit name的错误，哪位牛人能给我指点一下。
我在线等各位的解答。谢谢！！！

ljmmail 发表于 2010-12-24 22:07

select
t1.policyno,t1.insuredname ||' ',t1.appliname ||' ',t1.operatedate,
t1.startdate,t1.enddate,
t1.licenseno ||' 'aslicenseno ,t1.engineno ||' ' asengineno,t1.sumamount,t1.sumpremium,
t1.handler1code
from prpcmain t1
where comcode = '320112'
and riskcode = 'D'
and startdate between '20091001' and '20091031'
--and sfxinb = '1'
and underwriteflag in ('1','3')
and othflag !='1'
into temp t1;

liaosnet 发表于 2010-12-24 22:14

t1.insuredname ||' ',
改成 t1.insuredname ||' ' insuredname,
试下。。

一个菜鸟 发表于 2011-01-01 11:29

临时表的每一列都要有列名的不能默认

查看完整版本: 关于临时表的问题