Why can't we just use IN?
in SQL / SQL Self Join
emp_no IN (SELECT
3 answers ( 0 marked as helpful)
Thanks for reaching out.
Thank you for sharing your output with the Community!
As is the case for this task, sometimes there are several ways to obtain the desired answer. Nevertheless, this lecture is designed to explain the use of MySQL self-joins, hence the choice to use that technique for the solution of the given task.
Hope this helps.
Understood. Thank you for your response.
You are very welcome!
Submit an answer
Why did you not do not null, primary key and auto increment for customer id in the solution?