What types of SQL joins are you familiar with?

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