Question

1.36K viewsSeptember 19, 2024

0

Amit (anonymous) September 19, 2024 0 Comments

What is the difference between INNER JOIN and LEFT JOIN in SQL?

Write your answer.

score 0 · Answer 1 · 2024-09-19T08:52:40+00:00

INNER JOIN: This type of join returns only the rows that have matching values in both tables. If there is no match, the rows are not included in the result set.
LEFT JOIN (or LEFT OUTER JOIN): This type of join returns all the rows from the left table and the matched rows from the right table. If there is no match, the result is NULL on the side of the right table.