can i have an alias for the result table of inner join

Hi experts can i have an alias of the result of inner join of 2 tables? so that i can call the result of the table in its alias name

SELECT emp_table.Name, dept_table.dept
FROM dept_table
inner join emp_table
on emp_table.dept_id = dept_table.dept_id;