Skip to interview prep
Apexed

26. Explain INNER, LEFT and FULL OUTER joins.

EasyDatabases

Technical
Show model answer

INNER JOIN returns only rows with a match in both tables. LEFT JOIN returns every row from the left table, with NULLs where the right side has no match. FULL OUTER JOIN returns all rows from both sides, matching where possible.

Explain INNER, LEFT and FULL OUTER joins. — Software engineering interview question — Apexed