Question $3$

$2$ Points

Which type of join returns all rows from the left table and the matching rows from the right table, but excludes the unmatched rows from the right table?

INNER JOIN

LEFT JOIN

RIGHT JOIN

SELF JOIN