Well if you are looking to generate the resulted table basically you don't need to join those two tables.
Both table, if the EMPNO is common key then automatically both tables will be connected and you can get the result.
if you have only a few records in those tables it's ok to join two tables but if you have many records then Join will take time to load the data.
And one more thing if you want to load only those records of employees from the SALES table who are available in EMP table then you can you WHERE EXIST Condition.
load * from Emp;
load * from sales