sql查询
想把查询结果作为另一查询的表该如何做?
1、sele a,b, sum(c) as c into cursor t from d where e="2" group by a,b
从表D中汇总e='2',a,b相同的c 到临时表t中;
2、sele * from t where c<>0
从临时表t中选出c<>0的。
我分开执行可以,但我认为可以整合为一句。该如何办?
下列语句不行:
sele * from (sele a,b, sum(c) as c into cursor t from d where e="2" group by a,b)where c<>0
from后面的子查询该怎么写?
[此贴子已经被作者于2007-10-27 21:30:14编辑过]