in Databases
774 views
3 votes
3 votes

Which one is the more suitable answer for the following question, equijoin or natural join?

in Databases
774 views

4 Comments

not at all true! the way we join the tables tells us about the type of the join. projection doesn't play any role in joins.
0
0
the query above written(in qsn) is implicit represenation of NATURAL JOIN...

though explicitly we need not to write above query while calling natural join(we have to just write NATURAL JOIN in our query) but implicitly isn't it working of NATURAL JOIN ??
0
0
It is a Natural Join.

1. Natural join deals only with comparing columns with same data.

2. Natural join is an Equi Join. An Equi join deals with only a "=" operator. That means Equi join can also be Inner      Join and outer join (left and right)

If I have to choose, I'll choose the most the most basic definition.
0
0

1 Answer

1 vote
1 vote
The SQL NATURAL JOIN is a type of EQUI JOIN and is structured in such a way that, columns with the same name of associated tables will appear once only. 

In equi join we need to explicitly put the "=" operator 

This is an example of natural join:
-----------------------------------------
SELECT *
FROM table1
NATURAL JOIN table2; 

Example of Equi join(All natural joins are equijoins by definition):

SELECT column_list 
FROM table1, table2....
WHERE table1.column_name =
table2.column_name; 

Hence in the above question both the answers are correct A and C.

1 comment

I agree to your point! both are correct options!
0
0

Related questions

1 vote
1 vote
0 answers
2