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.

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

Follow this topic

Abrar Muhtasim

Last answered:

23 Mar 2022

Posted on:

19 Feb 2022

left join assignment answer

in SQL / Why SQL?

1 answers ( 0 marked as helpful)

Tsvetelin Tsonkov

Instructor

Posted on:

23 Mar 2022

left join assignment answer

Submit an answer

related questions