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? 
1 answers ( 0 marked as helpful)
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.
Best,
Tsvetelin