Resolved: JOIN in the video example
'dept_emp' have column 'emp-no' , why we have to join with employees table then ?!
i try it without employees join , it give the same result .
Thanks for reaching out.
The employees table is our main table of reference where solely the emp_no column is a primary key. Therefore, as a matter of better practice, we tend to involve it in our queries when appropriate. Anyway, your code is also valid.
Hope this helps.