SAS - SQL-JOINS-FULL JOIN

nThe FULL JOIN keyword return rows when there is a match in one of the tables.

Syntax:

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

Query:

SELECT EMPtbl1.EMPname, EMPtbl1.salary,EMPtbl2.comapny1
FROM EMPtbl1
FULL JOIN EMPtbl2 ON EMPtbl1.EMPid=EMPtbl2. EMPid1
ORDER BY EMPtbl1.EMPname