Natural join vs. inner join in sql

I am working with sql and doing exercises from w3resource. There is exercise where they used NATURAL JOIN as solution:
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?

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

Thanks. It turned out I overthinked it.

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