---

Natural Join

---

A natural join will join two datasets on all matching column names, regardless of whether the columns are actually related in anything other than name.

Example: Table1 and table2 share common column name and natural join between two tables

Table1

Table2

select * from table1 natural join table2;

---

Output of natural join

---

---