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?

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

Follow this topic

kfir ben galil

Last answered:

28 Sept 2022

Posted on:

26 Sept 2022

general question about the exercise

in SQL / SQL Subqueries nested in SELECT and FROM

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

28 Sept 2022

general question about the exercise

Submit an answer

related questions