Natural Join

A join matching equally named columns automatically and returning one copy of each matched column.

What is Natural Join in a relational database?

Natural Join — A join matching equally named columns automatically and returning one copy of each matched column.

SELECT customer_id, order_id
FROM customer
NATURAL JOIN purchase_order;

Level: Master · More Database terms at this level

Updated