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;
请问是为什么？
通过id做左连接，两个表都应该有id这个字段才行，参见下面代码，注意红色的标注；其实这就是关系数据库通用的SQL语句
proc sql;
select p.product,s.total
from one as p
left join
(select id,sum(sales) as total
from two ) as s
on p.id=s.id;
quit;
青衣默东行 发表于 2017-1-9 13:19
按照您改进的程序运行结果是：
product total
1001 800
需要对id进行分组
proc sql;
select p.product,s.total
from one as p
left join
(select id, sum(sales) as total
from two group by id) as s
on p.id=s.id;
运行结果
producttotal
1001500
1002.
1003200
扫码加好友，拉您进群
全部版块
我的主页
收藏
