What are the different types of joins in SQL?

Question

Accepted Answer

SQL joins combine rows from two or more tables based on related columns, enabling complex queries and data retrieval.

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 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 two tables, combining all rows. Example: SELECT * FROM A CROSS JOIN B;

Top Associate Consultant Interview Questions Asked at Infosys