Natural join vs. inner join in sql

Databases
1

I am working with sql and doing exercises from w3resource. There is exercise where they used NATURAL JOIN as solution: https://www.w3resource.com/sql-exercises/sql-joins-exercise-7.php
As I understand NATURAL JOIN is just shortcut to avoid typing.
But exercise require that

the same column of each table have to appear once and only the relational rows will come

. How that can be done with INNER JOIN?

2

yes, but that is its weakness

by not using the dreaded, evil “select star” ™

in the SELECT list, include only one of the join columns from each table

1 Like
3

Thanks. It turned out I overthinked it.

4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.