Last answered:

28 Sept 2022

Posted on:

26 Sept 2022


general question about the exercise

Hi, in the code below i get the same results without having to JOIN employees with dept_emp.
So generly speaking, what was the need for the the  JOIN?
Is it because every employee could be in more than one department, and so we had to make sure
that there are no duplicates?  image

1 answers ( 0 marked as helpful)
Posted on:

28 Sept 2022


Hi Kfir!
Thanks for reaching out.

Do you ask about the subquery for the employee with number 110022? This is made to ensure that such an employee exists in the table.

Looking forward to your answer.

Submit an answer