Oct 08, 2026 by Offer

SQL: joins explained (How To Answer): Interview Answer Guide 2027

SQL joins combine rows from two tables on a related column: INNER JOIN keeps only matching rows, LEFT JOIN keeps every left-table row plus matches, and FULL OUTER JOIN keeps everything. A solid sql joins interview question answer sketches the Venn diagram, states which side's rows survive, and warns about NULL keys and accidental row multiplication.

What the Sql Joins Interview Question Tests

Whether you can state precisely which rows each join type returns — not just draw the Venn diagram.
Whether you know the failure modes: NULL keys never match, and one-to-many joins multiply rows.
Whether you can write the syntax correctly under pressure, including the ON clause.

How to Answer the SQL Joins Interview Question

Answer in this order — concept, then syntax, then gotchas:

State the survival rule for the join being asked about in one sentence.
Write the query. `SELECT c.name, o.amount FROM customers c LEFT JOIN orders o ON c.id = o.customer_id;`
Explain the ON clause — it defines what counts as a match.
Name the traps: NULL keys never match; duplicate keys multiply rows; forgetting the ON clause gives a cross join.

Sample 30-second answer: "A left join keeps every row from the left table and attaches matching right-table rows, NULLs where nothing matches. Syntax is FROM customers LEFT JOIN orders ON customers.id = orders.customer_id. The traps are NULL join keys, which never match, and non-unique keys, which explode the row count."

Common Mistakes With the Sql Joins Interview Question

Saying LEFT JOIN 'joins left to right' without stating it preserves all left-table rows — the survival rule is the whole point.
Forgetting NULLs: NULL never equals NULL, so rows with NULL keys silently vanish from inner joins.
Joining on non-unique keys and exploding the row count — always check key uniqueness first.

SQL joins are the most-asked technical topic in data interviews because they are easy to test and easy to get subtly wrong. Candidates who can explain row survival and NULL behavior outrank those who just memorize the Venn diagram.

Keep Reading

FAQ

What is the difference between INNER JOIN and LEFT JOIN?

INNER JOIN returns only rows with matches in both tables. LEFT JOIN returns every row from the left table, filling NULLs where the right table has no match.

When would you use a FULL OUTER JOIN?

When you need all rows from both tables — e.g., reconciling two customer lists to find who appears in only one. Unmatched sides get NULLs.

What does CROSS JOIN do?

It returns the Cartesian product: every row of table A paired with every row of table B. Useful for combinations, dangerous on large tables.

Why did my join return more rows than expected?

Almost always a many-to-many or one-to-many key: duplicate join keys multiply rows. Deduplicate keys or aggregate before joining.

Preparing for Bloomberg's interview? Our 2027 Bloomberg Plum Online Assessment & Video Interview Tutorials has practice questions and answers — $79 one-time, instant download.