论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 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[1,6] = '320112'
  and riskcode[1] = 'D'
  and startdate between '20091001' and '20091031'
--and sfxinb[1] = '1'
  and underwriteflag in ('1','3')
  and othflag[4] !='1'
into temp t1;
我在使用上面语句在informix提数时，出现Virtual column must have explicit name的错误，哪位牛人能给我指点一下。
我在线等各位的解答。谢谢！！！

临时表

文库|博客

ljmmail

丰衣足食

论坛徽章:: 0

2楼 [报告]

发表于 2010-12-24 22:07 |只看该作者

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