"vitual colnmu must have explicit name"

lnkamu

“虚拟列须有显式名称”？
select  a.name.........，a.x+b.y from a,b into temp tem_ab where''
请问如何指定临时表的字段名称，如creat temp tem_ab(  )
会覆盖么？

john_student

形如:

1. 
   
2. select a.col1, a.col2, a.col3+b.col3 as newcol3, b.col4, ...
   
3. from a. b
   
4. where ...
   
5. into temp c
   

复制代码

amiescort

或者：
select a.col1 newcol3,a.col2 newcol4
from ……
也行