This content has been marked as final. Show 2 replies
You could try..
select e.last_name,e.department_id,c.last_name from employees e join employees c on ( e.department_id=c.department_id --"Add the below condition" and e.employee_id != c.employee_id ) and e.department_id=20;
i think it was all about syntax but man u showed me tht it was aal about intelligence :)