On Self Joins video (4:13)
The code is":
USE sql_hr;
select *
from employees e
join employees m
on e.reports_to = m.employee_id
Does the bolded line command to create a new table ??
I need to get this clear.
Thank you
Please set the topic of your questions to SQL, so others can find them in the future 
No, no new table is created. You just get a temporary overview of your data, where you find the manager of the employee.
In a later lesson you will learn about Views, which is a way to save these overviews, and they auto update with your data.