标题: 再问一个关于sql的having的问题 [打印本页] 作者: shiyiming 时间: 2005-3-27 11:56 标题: 再问一个关于sql的having的问题 原来程序是这样的：
proc sql;
connect to oracle as a(user=a orapw=aa path=aaa);
create table a.sales as
select * from connection to a
(select anum,product,sales1,sales2,......sales12
from b.sales
where anum>0
group by anum, product
having sum( sales1 +
sales2 +
......
sales12 ) > 0
order by anum , product);
run;