SAS - SQL-JOINS-RIGHT JOIN

nThe RIGHT JOIN keyword Return all rows from the right table (table_name2), even if there are no matches in the left table (table_name1).

Syntax:

SELECT column_name(s)
FROM table_name1
RIGHT JOIN table_name2
ON table_name1.column_name=table_name2.column_name

Query:

SELECT EMPtbl1.EMPname, EMPtbl1.salary,EMPtbl2.comapny1
FROM EMPtbl1
RIGHT JOIN EMPtbl2 ON EMPtbl1.EMPid=EMPtbl2. EMPid1

    ORDER BY EMPtbl1.EMPname