What is the difference between INNER JOIN and LEFT JOIN?
Model answer
INNER JOIN returns only rows with a match in both tables. LEFT JOIN returns every row from the left table, and the right-side columns are NULL when there is no match. Use LEFT JOIN when you want to keep rows even without related data, like customers with no orders.
Learn this topic
SQL JOINs: INNER JOIN and LEFT JOIN Explained in the course SQL for Beginners: Learn Databases Step by Step.
Sign in to add your own answer.