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.