289 views
1 votes
1 votes

If a question asks anything about 'Join' without describing what sort of join it is, should I consider that as a cross product join or Natural Join?

(PS: As far as my knowledge goes, Natural join is almost equivalent to Inner Join and not Cross product.)

Refer this question : https://gateoverflow.in/1471/gate1999-1-18-isro2016-53

1 Answer

0 votes
0 votes

Hello @Warlock lord  Without anything if in any question it says Join simply then always consider the Natural Join as a rule of thumb. In other join cases, some identification will always be given so as it recognize the join type. Hope it clears your query!

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