difference in inner join and outer join in mysql
The INNER JOIN takes data from both tables returns the
specified data exists in both tables. But the OUTER JOIN check both
tables and returns values from the outer table when the criteria mets.
Other major join are LEFT OUTER JOIN, RIGHT OUTER JOIN.
