Databases & SQL

What is SQL JOIN?

A JOIN combines rows from two or more tables based on a related column. INNER JOIN keeps matching rows only; LEFT JOIN keeps all rows of the left table and fills missing matches with NULL.