SAS - SQL-JOINS-LEFT JOIN

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

Syntax:

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

Query:

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