Explain INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN with examples.

Answer preview

A join combines rows from two tables using a predicate, usually a foreign key match. The join type decides what happens to rows that find no match on the other side: INNER drops them, the OUTER variants keep them and pad the missing side with NULL.…