What is difference between Inner vs Self vs Cross?

Sharad Jaiswal
Sharad Jaiswal

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.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Appinventiv Php Developer Interview Questions

    What is Interface? Why it is used?

    An interface can be defined as a platform that permits users to develop programs that mention all public methods that need to be implemented by various classes. It does not involve any complexity or d...