The short answer
NATURAL JOIN automatically joins tables using columns with the same names.
Example:
SELECT *
FROM customers
NATURAL JOIN orders;The problem is that the join condition isn't explicitly written.
Suppose today both tables have:
customer_idand tomorrow someone adds another column with the same name, the behavior of the query could unexpectedly change.
That's why production SQL usually prefers explicit joins:
ON customers.customer_id = orders.customer_idHow to say it
> NATURAL JOIN is dangerous because schema changes can silently change the join condition.