Hi
I am new to sql , and I am confused about how to write the joined columns on the self join
for Example :
select emp.last_name,emp.hire_date,mgr.last_name,mgr.hire_date
from employees emp
join
employees mgr
on (emp.employee_id=mgr.manager_id) ----------(1)---------vs------(2)------- on(mgr.employee_id=emp.manager_id)
where emp.hire_date<mgr.hire_date
I am using the employees table on hr schema
Thanks!