What are different types of joins and their examples?

Question

Accepted Answer

Different types of joins are Inner Join, Left Join, Right Join, and Full Outer Join.

Inner Join returns only the matching rows from both tables.
Left Join returns all the rows from the left table and matching rows from the right table.
Right Join returns all the rows from the right table and matching rows from the left table.
Full Outer Join returns all the rows from both tables.
Examples: Inner Join - SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Left Join - SELECT * FROM table1 LEFT JOIN table2 ON table1.column = table2.column
Right Join - SELECT * FROM table1 RIGHT JOIN table2 ON table1.column = table2.column
Full Outer Join - SELECT * FROM table1 FULL OUTER JOIN table2 ON table1.column = table2.column

Popular interview questions of Internship Trainee