Syntax, SELECT statement
for outer join:
SELECT column-1<,...column-n>
FROM table-1
| view-1 NATURAL JOIN table-2
| view-2
<other
clauses>;
NATURAL JOIN
specifies the type
of join.
table
specifies the name
of the source table.
<other clauses>
refers to optional
PROC SQL clauses.
|
proc sql;
select *
from certadv.schedule natural join
certadv.courses
;
quit;