0 votes 0 votes When no condition is applied on a join, then it is a natural join????? nishant_magarde asked Dec 12, 2018 nishant_magarde 262 views answer comment Share Follow See all 4 Comments See all 4 4 Comments reply Satbir commented Dec 12, 2018 i edited by Satbir Dec 12, 2018 reply Follow Share 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 votes 0 votes nishant_magarde commented Dec 12, 2018 reply Follow Share ok 0 votes 0 votes Satbir commented Dec 12, 2018 reply Follow Share https://gateoverflow.in/274266/sql-doubt you can check this 0 votes 0 votes nishant_magarde commented Dec 12, 2018 reply Follow Share understood. :) 0 votes 0 votes Please log in or register to add a comment.