General form, SELECT
statement for inner join (alternate syntax):
SELECT column-1<,...column-n>
FROM table-1
| view-1
INNER
JOIN
table-2
| view-2
ON join-condition(s)
<other
clauses>;
INNER JOIN
is a keyword.
ON
specifies join-condition(s),
which are expression(s) that specify the column or columns on which
the tables are to be joined.
<other clauses>
refers to optional
PROC SQL clauses.
|