Category Archives: mysql

MySQL – Left Join Table of content Unlike inner join, which provides the intersection values of two tables, there is another type of join called Outer Join. This outer join provides the collection of matched and unmatched records of two tables in multiple cases. MySQL Left Join Left Join is a type of outer join […]

MySQL – Cross Join Table of content MySQL Cross Join A MySQL Cross Join combines each row of the first table with each row of second table. It is a basic type of inner join that is used to retrieve the Cartesian product (or cross product) of two individual tables (i.e. permutations). A Cartesian product, […]

MySQL – Right Join Table of content MySQL Right Join The Right Join or Right Outer Join query in MySQL returns all rows from the right table, even if there are no matches in the left table. So, if zero records are matched in the left table, the right join will still return a row […]