Why not joining the emp_manager table instead?
Hello, I was wondering why using the dept_manager table instead of the emp_manager table for this exercise? A bit confused about these two tables. Thanks!
1 answers ( 0 marked as helpful)
Hi Kelly!
Thanks for reaching out.
This is because the dept_manager table contains data for managers. The emp_manager table is a table with 40 rows that shows some employees and their managers.
Hope this helps.
Best,
Tsvetelin