FULL OUTER JOIN in MySQL

SQL FULL OUTER JOIN: FULL OUTER JOIN returns all records when there is a match in left (Table1) or right (Table2) table records. FULL OUTER JOIN returns all matching records from both tables whether the other table matches or not. So, if there are rows in "Table1" that do not have matches in "Table2", or if there are rows in "Table2" that do not have matches in "Table1", those rows will be listed as well. NOTE: 1. FULL OUTER JOIN and FULL JOIN are the same. 2. FULL OUTER JOIN can return very large result-sets. SYNTAX: SELECT columnName FROM Table1 FULL OUTER JOIN Table2 ON Table1.columnName = Table2.columnName WHERE condition; BUT...... Support FULL [OUTER] JOIN by rewriting with UNION https://dev.mysql.com/worklog/task/?id=1604 -------------------------------------------- Please share & subscribe!!! --------------------------------------------