proc sql;
select p.product,s.total
from one as p
left join
(select sum(sales) as total
from two as s)
on p.id=s.id;
quit;
提示
84 proc sql;
85 select p.product,s.total
86 from one as p
87 left join
88 (select sum(sales) as total
89 from two as s)
90 on p.id=s.id;
ERROR: 列 total 在表/视图中未找到,其相关名为 S.
91 quit;
请问是为什么?