1,135 views
3 votes
3 votes

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

1 Answer

1 votes
1 votes
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.

Related questions

0 votes
0 votes
0 answers
1
aditi19 asked May 8, 2019
775 views
how to write the query for natural join on three relations in SQL using the NATURAL JOIN clause?
1 votes
1 votes
0 answers
2
0 votes
0 votes
1 answer
3
Shamim Ahmed asked Jan 8, 2019
712 views
Suppose we have 2 tables R1(ABCD), R2(DE) . R1 has 500 entries whereas R2 has 1500 entries. Here D is a candidate key. If we join them using natural join. How many entire...