What is the difference between INNER JOIN and LEFT JOIN in SQL?
adminnewd Changed status to publish September 19, 2024
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(orLEFT 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 isNULLon the side of the right table.
anonymous Answered question September 19, 2024
Write your answer.