Delete comment from: Java67

sheldom said...

Your query:
select distinct e.emp_id, e.emp_name from employee e join employee m on e.emp_id=m.mgr_id;
is equal to this another one:

select emp_id, emp_name from employee where emp_id=mgr_id; ???

how can i do know when i have to use a SELF JOIN or a simple query on the table??

Thx

Jan 26, 2016, 5:40:32 PM

Posted to Difference between Self and Equi Join in SQL - INNER Join example MySQL