SAS - SQL-JOINS-INNER JOIN

nThe INNER JOIN keyword return rows when there is at least one match in both tables.

 Syntax:

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

Query:

SELECT EMPtbl1.EMPname, EMPtbl1.salary,EMPtbl2.company1
FROM EMPtbl1
INNER JOIN EMPtbl2 ON EMPtbl1.EMPid=EMPtbl2.EMpid1

   ORDER BY EMPtbl1.EMPname