select 1 as a1,2 as a2,a1+a2 as b1,(a1+a2)*2 as b2,(a1+a2)*2+3 as b3 from table1有什么好方法能实现字段嵌套?象这样的方式:
select 1 as a1,2 as a2,a1+a2 as b1,b1*2 as b2,b2+3 as b3 from table1现在我只能自己编写一个视图生成器来实现。
select 1 as a1,2 as a2,a1+a2 as b1,b1*2 as b2,b2+3 as b3 from table1现在我只能自己编写一个视图生成器来实现。
表嵌套很囧啊。一个引用字段字段就得嵌套一层子表,会更麻烦的。to:ldslove
“正解查询”是什么?
如果是指SQL SERVER提供的字段公式,那个也不能嵌套的。