left join assignment answer
There are 24 manager in department manager table and one manager with last name 'markovitch' . I guess in assignment you asked to find the manager whose last name is 'markovitch'. so, there should be 1 row affected instead of 181.
1 answers ( 0 marked as helpful)
Thanks for reaching out.
This will be the case if we use RIGHT JOIN. Since we use LEFT JOIN we obtain as a result set all records from the left table and the matched from the right table. Actually, the managers are also in the employees table.
Hope this helps.
Submit an answer
Resolved: unable to download resources that are related to the only the assignment sections!