NATURAL JOIN

NATURAL JOIN is a SQL clause in the JOIN Types category. Joins tables automatically on columns with the same name. Avoid in production — implicit behavior can be surprising. The syntax is SELECT * FROM table1 NATURAL JOIN table2;. It returns joined result on common columns. A typical example: SELECT * FROM employees NATURAL JOIN departments; -- Automatically joins on same-named columns A close relative is INNER JOIN, which returns only rows where there is a match in BOTH tables. The most common JOIN type. A close relative is LEFT JOIN, which returns ALL rows from the left table and matching rows from the right. Unmatched right rows show NULL. A close relative is RIGHT JOIN, which returns ALL rows from the right table and matching rows from the left. Opposite of LEFT JOIN. More about this category: Table join operations — INNER, LEFT, RIGHT, FULL, CROSS, SELF JOIN.