Implementing FULL JOIN in MySQL
There is no natively implemented Outer Join in MySQL.\n But we can implement OUTER JOIN in MySQL by taking a LEFT JOIN and RIGHT JOIN union.\n If column names o
* There is no natively implemented Outer Join in MySQL.\n* But we can implement **OUTER JOIN** in MySQL by taking a LEFT JOIN and RIGHT JOIN union.\n* If column names of two tables are identical, we can use the USING clause instead of the ON clause.\n```\nSELECT T.employee_id\nFROM  \n  (SELECT * FROM Employees LEFT JOIN Salaries USING(employee_id)\n   UNION \n   SELECT * FROM Employees RIGHT JOIN Salaries USING(employee_id))\nAS T\nWHERE T.salary IS NULL OR T.name IS NULL\nORDER BY employee_id;
['Union Find', 'MySQL']