Question

What is a natural join?

Answer 1

In a natural join, columns with the same name will appear only once.

EX. SELECT * FROM EMP NATURAL JOIN EMPSALARY;

| EID | ENAME | AGE | SALARY |
| 111 | AAA | 40 | 40000 |
| 222 | BBB | 45 | NULL |
| NULL | CCC | NULL | 50000 |