in Databases
263 views
0 votes
0 votes
When no condition is applied on a join, then it is a natural join?????
in Databases
263 views

4 Comments

edited by
no. when we join using a common attribute then it is called natural join . it is represented with *.

If there are no common elements and we join then it becomes Cartesian product. It is represented by X.

In the condition if we compare an attribute with a constant then it is called theta join. Like A>100.
0
0
ok
0
0
0
0
understood. :)
0
0

Please log in or register to answer this question.