SQL问题
SELECT bq,zr,zx,yx,strt(strt(strt(strt(strt(strt(hc3pxtc,x1,'**'),x2,'**'),x3,'**'),x4,'**'),x5,'**'),x6,'**') zd0 FROM tmp000 INTO CURSOR tmp9991SELECT bq,zr,zx,yx,(at('**',zd0,1)+2)/3 x1,(at('**',zd0,2)+2)/3 x2,(at('**',zd0,3)+2)/3 x3,(at('**',zd0,4)+2)/3 x4,(at('**',zd0,5)+2)/3 x5,(at('**',zd0,6)+2)/3 x6 FROM tmp9991 INTO CURSOR tmp9992
上面的9.0能通过,想两句并一句缩短运行时间,可转换成下面就出错,是什么原因?
SELECT bq,zr,zx,yx,(at('**',zd0,1)+2)/3 x1,(at('**',zd0,2)+2)/3 x2,(at('**',zd0,3)+2)/3 x3,(at('**',zd0,4)+2)/3 x4,(at('**',zd0,5)+2)/3 x5,(at('**',zd0,6)+2)/3 x6 FROM (SELECT bq,zr,zx,yx,strt(strt(strt(strt(strt(strt(hc3pxtc,x1,'**'),x2,'**'),x3,'**'),x4,'**'),x5,'**'),x6,'**') zd0 FROM tmp000) INTO CURSOR tmp9992