Question: what is inner join and outer join in sql with examples?
Answer: Here are the different types of the JOINs in SQL: (INNER) JOIN: Returns records that have matching values in both tables. ... RIGHT (OUTER) JOIN: Returns all records from the right table, and the matched records from the left table. FULL (OUTER) JOIN: Returns all records when there is a match in either left or right table.