Mysql join, Select data from multiple table rows using JOIN

The FULL OUTER JOIN retrieve all rows from the left table (table1) and from the right table (table2). If there is no match in left table then return null. MySQL doesn't support FULL OUTER JOIN Syntax-SELECT column1, column2,...columN> FROM table1> FULL ..

tkhts.com