What are the different types of joins in SQL, and can you explain each of them?

Question

Accepted Answer

SQL joins combine rows from two or more tables based on related columns.

INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;
LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;
RIGHT JOIN: Returns all records from the right table and matched records from the left table. Example: SELECT * FROM A RIGHT JOIN B ON A.id = B.id;
FULL OUTER JOIN: Returns all records when there is a match in either left or right table. Example: SELECT * FROM A FULL OUTER JOIN B ON A.id = B.id;
CROSS JOIN: Returns the Cartesian product of both tables, combining all rows. Example: SELECT * FROM A CROSS JOIN B;

Top Manual Test Engineer Interview Questions Asked at INDIUM