Which SQL procedure program procedures the same results?

Given the SAS data sets ONE and TWO:

The following SAS program is submitted:

Data combine;

Merge one two;

By id;

Run;

Which SQL procedure program procedures the same results?
A . proc sql;
Create table combine as
Select coalesce (one.id, two.id) as id,
Name,salary from one, two where one.id=two.id;
Quit;
B . proc sql;
Create table combine as
Select one.id,
Name, salary from one full join two where one.id=two.id;
Quit
C . proc sql;
Create table combine as
Select one.id,name,salary from one inner join two on one.id=two.id
Quit
D . proc sql;
Create table combine as
Select coalesce (one id, two id) as id,
Name,salary from one full join two on one.id=two.id;
Quit;

View Answer

Answer: D