PHP SQL Right Join
JOIN is used to query data from two or more tables. The right join is used in case of need to return all rows from the right table, even if the left table doesn't have any match.
Mysql Cross Join
Cross Join is also called Cartesian Product Join. The Cross Join in SQL return you a result table in which each row from the first table is combined with each rows from the second table.
Mysql Natural Join
Mysql Natural Join is a specialization of equi-joins. The join compares all columns in both tables that have the same column-name in both tables that have column name in the joined table.