Additional Notes
How would you explain an OUTER JOIN, and how does it differ from INNER JOIN in an interview?
Track: Java
Topic: SQL for Java Devs
Focus: JOINs
Java: JOINs
Answer
An OUTER JOIN returns all rows from one table and the matched rows from another.
Unlike INNER JOIN, which only returns rows with matches in both tables, an OUTER JOIN returns all rows from one table and matched rows from the other, filling in NULLs for non-matching rows. This is useful when you want to include all entries from one table, like all suppliers, regardless of whether they have products.
Unlike INNER JOIN, which only returns rows with matches in both tables, an OUTER JOIN returns all rows from one table and matched rows from the other, filling in NULLs for non-matching rows. This is useful when you want to include all entries from one table, like all suppliers, regardless of whether they have products.
Topics: Java JOINs SQL for Java Devs