0 votes 0 votes closed with the note: duplicate Can we say inner and self join are same ? Databases natural-join databases + – set2018 asked Sep 29, 2017 • closed Sep 29, 2017 by set2018 set2018 363 views comment Share Follow See 1 comment See all 1 1 comment reply set2018 commented Sep 29, 2017 reply Follow Share natural join :The result of the natural join is the set of all combinations of tuples in R and S that are equal on their common attribute names Source :https://en.wikipedia.org/wiki/Relational_algebra#.CE.B8-join_and_equijoin inner join :'inner join' is opposed to 'outer join' and determines how to join two sets when there is no matching value. source :https://stackoverflow.com/questions/5471063/is-inner-join-the-same-as-equi-join equi join:'equi-join' means joining tables using the equality operator or equivalent. theta join :θ is a binary relational operator in the set {<, ≤, =, >, ≥}, v is a value constant, and R and S are relations. The result of this operation consists of all combinations of tuples in R and S that satisfy θ. The result of the θ-join is defined only if the headers of S and R are disjoint, that is, do not contain a common attribute. 0 votes 0 votes Please log in or register to add a comment.