Which table should be Table 1?
As we are going to extract information about the managers then why we are considerig employees table as table 1 instead on dep_manager_dup table?
1 answers ( 0 marked as helpful)
Hi Raza!
Thanks for reaching out.
Actually, the employees tables is not used in this query. As you stated the two tables should be - dept_manager_dup and departments_dup.
Hope this helps.
Best,
Tsvetelin