
平臺(tái) 論壇博客文庫(kù)

› 論壇 › 數(shù)據(jù)庫(kù)技術(shù) › Informix › 關(guān)于臨時(shí)表的問(wèn)題

最近訪問(wèn)板塊

查看: 58933 | 回復(fù): 3

關(guān)于臨時(shí)表的問(wèn)題 [復(fù)制鏈接]

B06022208

白手起家

論壇徽章:: 0

電梯直達(dá)

1樓 [收藏(0)] [報(bào)告]

發(fā)表于 2010-11-02 15:20 |只看該作者 |倒序?yàn)g覽

本帖最后由 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;
我在使用上面語(yǔ)句在informix提數(shù)時(shí)，出現(xiàn)Virtual column must have explicit name的錯(cuò)誤，哪位牛人能給我指點(diǎn)一下。
我在線等各位的解答。謝謝�。�！

臨時(shí)表

文庫(kù)|博客

redis源碼閱讀補(bǔ)充說(shuō)明以及SDS的一點(diǎn)補(bǔ)充
mysql動(dòng)態(tài)sql批量刪除數(shù)據(jù)
redis源碼閱讀之a(chǎn)e_evport

ljmmail

豐衣足食

論壇徽章:: 0

2樓 [報(bào)告]

發(fā)表于 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;