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
Write your answer.