Equi-join contains the duplicate columns.
1 Like
True
Reason — In an equi-join, all columns from the joining tables are included in the output, even if they are identical, which can lead to duplicate columns in the output.
Answered By
Non-equi-join is the name of Natural join.
Natural join contains the duplicate columns.
Inner Join combines only the matching rows from the two tables.
A join condition can only use equality for comparison.