p***7
发帖数: 535 | 1 ONE
YEAR QTR BUDGET
2001 3 500
2001 4 400
2002 1 700
TWO
YEAR QTR SALES
2001 4 300
2002 1 600
Proc SQL;
SELECT ONE.*, SALES
FROM ONE
LEFT JOIN TWO
ON ONE.YEAR=TWO.YEAR
WHERE ONE.YEAR=2001
QUIT;
The answer is A
A
YEAR QTR BUDGET SALES
2001 3 500 300
2001 4 400 300
B
YEAR QTR BUDGET SALES
2001 3 500 300
2001 4 400 300
2002 1 700 .
I think it should be B left join should include the rest of data in one
data set, right?
Please help! Thanks so much |
|
