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 .
2 answers ( 2 marked as helpful)
Hi Marwa!
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.
Best,
Tsvetelin
Thanks for your time and effort :)