in Databases
208 views
1 vote
1 vote

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

in Databases
208 views

1 comment

natural join will be mentioned in question.
0
0

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

1 vote
1 vote
0 answers
2