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)
Hi Abrar!
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.
Best,
Tsvetelin