medium10 pts · first answer countssqljoinsself-join

Showing each employee's manager

Why does this query use a LEFT JOIN rather than an INNER JOIN?

A.Because a table can never be INNER JOINed to itselfB.So each manager appears once per direct reportC.So staff with no manager, like the CEO, still appearD.Because LEFT JOIN runs faster on the same table

Discussion 0

Join free to post in the discussion.

Showing each employee's manager

Discussion 0

Related questions