Posted On: Feb 22, 2018
Inner Join: Inner Join can also be called the simple join. It allows the coder to filter the outcomes of the cartesian product by some predicate.
Self Join: It is used to join one single table with itself as there were two different tables.
Cross Join: This is the basic join, it is nothing but a cartesian product. This join method compares every single row of a table with every single row of the other table.
Never Miss an Articles from us.