adv 63题中的55 为什么是full join？

如果是full join的话应该包含所有的row啊，为什么one里的2003没有了呢。
而且重复的year也应该是两列啊。多谢啦！
Given the SAS data sets: WORK.ONE           WORK.TWO
Year Qtr Budget      Year Qtr Sales
---- --- ------ ---- --- -----
2001 3 500               2001 4 300
2001 4 400               2002 1 600
2003 1 350
The following SAS program is submitted:
proc sql;
select TWO.*, budget
from WORK.ONE
[_insert_join_operator_]
WORK.TWO
on ONE.Year=TWO.Year ;
quit;
The following output is desired:
Year Qtr Sales Budget
---- --- ----- ------
2001 4 300 500
2001 4 300 400
2002 1 600 .
.        .  .      350
Which join operator completes the program and generates the desired output?
A. left join B. right join C. full join D. outer join

select TWO.*, budget
注意选的变量为：TWO.Year TWO.Qtr TWO.Sales ONE.budget，
所以year只出现一次

stayhungry05 发表于 2015-10-30 04:09
select TWO.*, budget
注意选的变量为：TWO.Year TWO.Qtr TWO.Sales ONE.budget，
所以year只出现一次

多谢，明白了